Questions tagged as 'oracle'

Tagged questions
1
answer

How to configure output size in SqlDeveloper's "script" option

Oracle - SqlDeveloper - Version 4.1.3.20 Build MAIN-20.78 When executing a SQL block I have two options (Execute Statement or Execute Script), in this option, after an update done, a limitation exists on the output size, at what point of SqlD...
asked by 22.07.2016 / 21:32
1
answer

Trigger prevents table change

I need to make a trigger that will prevent the same employee from joining more than one crew on the same day. The crew table is as follows: Tripulação = {id_Voo, data, id_Funcionário } The 3 attributes are together the primary key. Wh...
asked by 21.01.2016 / 13:07
1
answer

Insert a select with more than one result

I need to run the following command in an ORACLE DB: Elaborate a select that returns more than one result and the result of this select need to use to make an insert in several lines. Ex: My select returned 2 results: A and B, these results s...
asked by 19.02.2016 / 20:26
1
answer

Case and Group by Error - Oracle SQL Developer

Hello, I'm trying to group the results of a query with case as follows: select case when sal BETWEEN 0 and 100000 then 1 when sal BETWEEN 100001 and 200000 then 2 when sal BETWEEN 200001 and 300000 then 3 when sal...
asked by 07.12.2015 / 18:25
1
answer

ORA-01799: a column may not be over-joined to a subquery

I am having a problem with oracle, it is not accepting a subquery in a left join, if I change to inner join it works, but it changes the result of my select then does not answer the solution. the problem happens with the following example:...
asked by 15.04.2016 / 15:59
1
answer

How to bring the fields name and type from an oracle table in C #

How do I get the name and type of fields in a table, using Oracle and C # (WPF)?     
asked by 17.02.2016 / 18:05
1
answer

Error fetching a list from the bank

Hey, guys, So I have a question in my college work, I have two tables one USER and USER_AMIGO both related, by java I'm looking for a user list that brings all users registered, and another list that brings a friend to a certain user, so I...
asked by 16.10.2015 / 23:14
1
answer

Error registered the JDBC driver [oracle.jdbc.driver.OracleDriver] but failed to unregister

I am making a JavaWeb system using jsp that is in this topic: Doubt in query database, error in query , and in a query with the database, I came across a driver error that is Right below. I use the netbeans IDE with server gl...
asked by 21.08.2015 / 20:59
1
answer

Java project with Oracle and MySQL at the same time?

Given an Oracle Database and a MySQL DB, and the impossibility of integrating both databases: Would it be possible, for example, to class my application 'look' at the mysql table and update an oracle table?     
asked by 04.05.2015 / 19:15
1
answer

Self-relationship doctrine

I'm using Doctrine, and now I have the following problem. I'm doing a system registry, where it can have multiple "children" and their "children" can also have "children", and so on. How will I achieve this self-relationship with the doctr...
asked by 13.04.2015 / 15:17