Questions tagged as 'sqldeveloper'

1
answer

Select max in nested queries

I have to select the candidate who has more publications than any of the other candidates. select candidato.nome, Count(1) as nr_publicacoes from candidato, cv,ficha_inscricao, publicacao_cv where candidato.bi = ficha_inscricao.bi and...
asked by 20.11.2015 / 10:06
2
answers

My dbms output is not displayed

I'm testing a simple output of DBMS in SQLDeveloper. I created the connection, I executed set serveroutput on to enable the DBMS outputs, but when I run my anonymous code block, in Saída do Script it displays the mess...
asked by 27.11.2017 / 17:56
1
answer

export import database oracle 11g sqldeveloper

The question is as follows, 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, exactly the same structure, that is everything in my local...
asked by 24.08.2017 / 15:38
2
answers

How to resolve the java.net.UnknownHostException error

I'm trying to install sqldeveloper and datamodeler in my Fedora 20 and I'm having problem with following error: java.net.UnknownHostException: localdomain: localdomain: Name or service not known at java.net.InetAddress.getLocalHost...
asked by 06.03.2014 / 01:28
1
answer

Error in query INSERT INTO

I'm new using Oracle SQL Developer and I'm trying to make the query run but this is a bug, see the photo.     
asked by 25.11.2017 / 22:29
1
answer

Delete 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 are repeated except the NDO field, and NDOGroup, are these fields that are duplicating the...
asked by 31.03.2017 / 14:26
1
answer

Tables are not shown in Oracle SQL Developer

I have multiple connections configured in TNSNAMES.ORA , and for some I can not see any tables if they expand the folder. The user I am connecting to has access because I make queries and insertions normally. I found a tip on the intern...
asked by 09.12.2015 / 17:34
1
answer

How to set Foreign key in oracle SQL developer?

I'm new using this program, how do you define Foreign key in oracle SQL developer?     
asked by 25.11.2017 / 18:29
1
answer

Dropping the tables from my schema in Oracle

I am using a Schema in Oracle (sql developer) and within my schema there are already several tables created that I was using previously. Now running a new script in this scheme it has the following error: Relatório de erros - ORA-00955: nome j...
asked by 05.11.2017 / 02:37
1
answer

Replace all '&' parameters of a query in SQLDeveloper

I have a query that uses multiple times the same parameter, in SQLDeveloper, calls Replacement Variable (VS), for example, &empresa . If you use this VS with the query below: SELECT * FROM pedido WHERE empresa = &emp...
asked by 07.06.2017 / 22:19