Questions tagged as 'sqldeveloper'

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

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

How to display SQL History in SQL Developer?

I need to view all of the alters in a procedure. The SQL Developer tool has a toolbar that stores a history of changes. How can I enable / view? Image of the functionality     
asked by 30.01.2018 / 14:29
1
answer

Problem setting Foreign key

I am now learning database. I do not understand why I'm not letting you set team_id as a foreign key.     
asked by 25.11.2017 / 19:25
1
answer

Error creating a simple table in Oracle SQL Developer

I'm having trouble creating the following table: CREATE TABLE T_AM_OME_ADVOGADO ( cd_pessoa NUMBER (8) NOT NULL , nr_oab NUMBER (8) NOT NULL , nr_cpf NUMBER (11) NOT NULL , nr_rg CHAR (10) NOT NULL , ds_email VARCHAR2 (128...
asked by 18.08.2016 / 21:18
1
answer

How to disable a constraint in ORACLE?

I have a table where two specific fields together can not have the same values. BELIEVE what they are: NUM_DIVISION COD_INDICATOR Assuming I have this data: NUM_PERIODO_LANCAMENTO = 1 , COD_INDICADOR = 1 , COD_CR_PERIODO = 1 NUM...
asked by 02.06.2014 / 17:05
1
answer

Select Scalar in PL / SQL - Oracle SQL Developer

I come from a T-SQL (MS SQL Server) background and have things that do not work the same in PL / SQL. I would like to know how to give a select in PL / SQL scalars. Examples in MS SQL Server Example 1: SELECT 1 + 1 Example 2: DEC...
asked by 09.04.2018 / 20:43
1
answer

Where does SQL Developer save the DB file?

Where do the banks I create in SQL Developer get saved? I would like to be able to choose the location / folder to save the Bank, but I do not know where it is saving.     
asked by 27.03.2017 / 22:11
1
answer

Debug function inside a package

I have a package with various functions and procs. How do I, using pl / sql developer, to debug? I would like to know how I go about the error and see what is being done. Using the pl / sql Tests tool I know I can debug. What happens is that...
asked by 03.12.2015 / 19:29
1
answer

SQL Developer 4.1.1 hangs in "Restoring Windows"

I downloaded SQL Developer 4.1.1 (4.1.1.19.59), but after the first use I can not open it. It hangs in the "Restoring Windows" process. Does anyone have the same problem? Did you find the solution? The only thing that has worked here so far has...
asked by 09.07.2015 / 13:43