Most voted "sqldeveloper" questions
Oracle SQL Developer is a free integrated development environment (IDE) for working with SQL in Oracle databases. Use this tag for questions directly related to Oracle SQL Developer, and not just because it is used in the development process.
Learn more…43 questions
Sort by count of
-
3
votes2
answers21001
viewsHow to resolve java.net.Unknownhostexception error
I’m trying to install the sqldeveloper and datamodeler in my Fedora 20 and I’m having trouble with following error: java.net.UnknownHostException: localdomain: localdomain: Name or service not known…
-
3
votes1
answer62
viewsSelect max in nested queries
I have to select the candidate who has more publications than any other candidate. select candidato.nome, Count(1) as nr_publicacoes from candidato, cv,ficha_inscricao, publicacao_cv where…
-
3
votes1
answer2370
viewsMy dbms output is not displayed
I’m testing a simple exit from DBMS in Sqldeveloper. I created the connection, ran the set serveroutput on to enable the exits DBMS, but when I run my anonymous code pad, on Saída do Script he…
-
3
votes1
answer1355
viewsPassword or invalid user when logging into oracle database (ORA-01017)
Good morning, everyone, I need to set up an environment for a course. For this I installed the Oracle database and SQL Developer. In the oracle database I have the SYS user working perfectly. The…
-
2
votes1
answer4598
viewsexport oracle database 11g sqldeveloper
The point is, I have a local database, where I already have the structure and data in the respective tables that I need. I want to export this database to another machine, with exactly the same…
-
2
votes1
answer888
viewsSQL Developer does not run on Ubuntu
I’m trying to run Oracle SQL Developer on Ubuntu and when it arrives in the image part below the execution gets stuck. I searched the internet but couldn’t find anything that could help me. Someone…
-
2
votes1
answer1424
viewsOracle SQL Developer Table Creation
create table socio ( id_socio integer Not NULL, nome varchar(256) not NULL, cpf varchar(11) not NULL, email varchar(256), id_situacao integer, constraint socio_id_socio_PK primary key(id_socio),…
-
2
votes1
answer109
viewsTwo SUM functions in Oracle SQL to return two different sums with two SELECT
I am running the following select on Oracle SQL Developer: SELECT SUM(FANFISCA.TOTAL_NF) AS TOTAL_FATURAMENTO, FANFISCA.CD_REPRESENTANT COD_REPRESENTANTE, GEEMPRES.NOME_COMPLETO REPRESENTANTE FROM…
sqldeveloperasked 4 years, 1 month ago Adair Juneo 47 -
1
votes1
answer622
viewsError Case and Group by - 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…
-
1
votes1
answer1788
viewsHow to set output size in Sqldeveloper "script" option
Oracle - Sqldeveloper - Version 4.1.3.20 Build MAIN-20.78 When running an SQL block there are two options (Run Instruction or Run Script), in this option , after an update is made, there is a…
-
1
votes1
answer1197
viewsDelete Duplicate Records by Group BY
Good morning, Does anyone know if there is a possibility to delete duplicate records as follows: I have a query that brings the result All fields repeat themselves except the NDO field, and…
-
1
votes1
answer928
viewsHow to set Foreign key in oracle SQL Speed?
I am new using this program, as defined Foreign key in oracle SQL?…
-
1
votes1
answer1114
viewsReplace all & parameters of a query in Sqldeveloper
I have a query that uses several times the same parameter, in Sqldeveloper, calls Substitution Variable (VS), for example, &empresa. If I use this VS with the query below: SELECT * FROM pedido…
sqldeveloperasked 7 years ago David 4,330 -
1
votes1
answer574
viewsDropper my schema tables on Oracle
I am using a Schema in Oracle (sql Developer) and within my schema there are already several tables created that I was using earlier. Now running a new script in this scheme it shows the following…
-
1
votes1
answer42
viewsProblem in defining Foreign key
I’m learning now database. I’m not getting why not let me set team_id as Foreign key.…
-
1
votes1
answer394
viewsError in query INSERT INTO
I’m new using Oracle SQL Developer and I’m trying to make the query run but this appearing error, see photo.…
-
1
votes1
answer1287
viewsHow to view SQL History in SQL Developer?
I need to view all changes in a trial. The SQL Developer tool has a toolbar that stores a history of changes. How can I enable/view ? Image of the fuctionality…
-
1
votes1
answer171
viewsTables Displayed in Oracle SQL Developer
Good Night, installed in my notebook the oracle database and the oracle sql: $! I would like to know how to display only the tables I created or create,and not display these others, since it leaves…
-
1
votes1
answer64
viewsSubquery with the records of a column
I have the following problem... I need to extract the information from a table where it has the following structure: tabela: PROCESSO_VALOR_TIPO Coluna : field_model_ids Dados :…
-
1
votes0
answers91
viewsInstead of Trigger to enter values - ORACLE
Summarizing my problem, I need to automatically insert values into a table after other values are entered into it. The way I found to do this on the Oracle was by using a Trigger of the kind INSTEAD…
-
0
votes1
answer5423
viewsHow to disable a Constraint in ORACLE?
I have a table where two specific fields together cannot have the same values. I BELIEVE who are they: NUM_PERIODO_LANCAMENTO COD_INDICADOR Assuming I have that data: NUM_PERIODO_LANCAMENTO = 1 ,…
-
0
votes1
answer1537
viewsSQL Developer 4.1.1 hangs on "Restoring Windows"
I downloaded version 4.1.1 (4.1.1.19.59) of SQL Developer, but after the first use I can’t open it anymore. It hangs in the "Restoring Windows" process. Does anyone have the same problem? Have you…
sqldeveloperasked 8 years, 11 months ago pinkoski 11 -
0
votes1
answer1155
viewsDebug Function within a package
I have a package with several functions and procs. How do I, using pl/sql Developer, debug? I would like to know how I go to the error and see what is being passed. Using the pl/sql Tests tool I…
-
0
votes2
answers4255
viewsTables are not shown in Oracle SQL Developer
I have several connections configured on TNSNAMES.ORA, and for some I cannot see any table if I expand the folder. The user I am connecting has access, because I do the queries and insertions…
-
0
votes1
answer1446
viewsWhere does SQL Developer save the BD file?
Where are the banks I create in SQL Developer saved ? I wish I could choose the location/folder to save the Bank, but I don’t know where it is saving.
-
0
votes0
answers327
viewsHow to create a new database in ORACLE?
I installed oracle database, oracle client e sql Developer num windows 8.1 64 bits. With the installation of the oracle database, a database was created at localhost:1521 But now I would like to…
-
0
votes1
answer1114
viewsError 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…
-
0
votes0
answers734
viewsSQL username and password
During the installation of SQL Developer 17.3.1 on Ubuntu 16.04, it did not ask user and password. In this case I cannot log in, is there any default user or some way to configure a user?
-
0
votes1
answer192
viewsHow to properly configure & character in SQL Developer 17.3
Hello friends I am trying to make a sql query in SQL Developer as follows: SELECT * FROM CLIENTE WHERE NOME_CLIENTE IN ('SALES & CIA AGUIAR', 'SAO JOAO') The tool is understanding the character…
-
0
votes1
answer231
viewsSelect Scale in PL/SQL - Oracle SQL Developer
I come from a background of T-SQL (MS SQL Server) and have things that do not work equally in PL/SQL. I would like to know how to select scalars in PL/SQL. Examples in MS SQL Server Example 1:…
-
0
votes1
answer161
viewsLISTAGG returning repeated values
Hello, everybody. Good afternoon. I have a query that concatenated several record using a certain key. However it brings some repeated values as a result. Below an example of a query: SELECT PEH.PN,…
-
0
votes1
answer203
viewsFind shift based on a given date time in ORACLE/sql
In a table X I have a date column that also returns the time, I wonder if, based on this time, I have how to create a column with the name of the turn. ex( if you have a die 20-02-2002 06:00:00 I…
-
0
votes1
answer1805
viewsSELECT inside a FOR in declare SQL/ORACLE
I need to generate an excel of a table data but I need to do for each my company, so n have to run select changing the company id I thought to do with Procedure but the ones I have and just update…
-
0
votes1
answer488
viewsHow to change the order of the parameters in Oracle SQL Developer
I have a question regarding the order of the parameters within SQL developer. Query for example: select * from conta_paciente where cd_convenio = :cd_conv and dt_conta between :dti and :dt In older…
-
0
votes1
answer116
viewssql server Developer 2017 installation error
When trying to install sql server Developer 2017 I get the following error message: "Opa... there was an error when checking the sql server configuration rules". Windows 10 Pro (but not enabled)…
-
0
votes1
answer142
viewsConnect BD sql server to sql
I am trying to connect my sql Developer to sql server, but it is not working. Password and user are correct. They know what the problem is?…
-
0
votes1
answer1315
viewsRun oracle database in sql
I know it may sound like a stupid question, but I’ve already googled it and I haven’t found anything concrete, I own a trial where her call is like this: PROCEDURE pr_rel_saldo(p_codigocliente IN…
-
0
votes0
answers74
viewsOracle SQL Developer - TO_CHAR Bugs
Good morning. I have a problem/doubt: Why is it not possible to use TO_CHAR more than once for the same field? And why does this influence the outcome of other fields? If someone can explain it to…
-
0
votes0
answers27
viewsHow do I use a previous condition on Oracle?
I’m having a hard time using two columns as a condition in Where. I don’t know if I can explain it properly, but: WHERE P.PROFILE_STATUS = '1' AND P.JOBTITLE NOT IN (' -…
-
0
votes0
answers230
viewsUse two fields with different settings on Oracle
I’m having a hard time: I’m trying to use a field that was created as number with a field created as NUMBER NOT NULL ENABLE. The ID_ACESSO field was created like this: "ID_ACESSO" NUMBER NOT NULL…
-
0
votes1
answer118
viewsProblem in the condition of Trigger - PL-SQL
My teacher passed that question: Write a Rigger that checks, during registration/change of a sale, the following: 1) The QUANTITY field of the ITEMVENDA table shall not have decimal places and shall…
-
0
votes1
answer85
viewsDivision of SUM() into SQL Developer
We are running the SELECT below in order to deliver a percentage difference between the somatic values PRECO_UNITION and PRECO_TABELA. We try to do this in the simplest way by performing the common…
-
-1
votes2
answers2755
viewsSQL to load only part of a string
I’d like some help. I have the following query below, however, I need that in the DE column bring only the texts after the word "Exclusion", and in the PARA column bring only the text from the word…