Questions tagged as 'sqldeveloper'

Hello everyone. Good afternoon. I have a query that I did concatenating multiple records using a given key. However, it brings some repeated values as a result. Here is an example of a query: SELECT PEH.PN, LISTAGG (PEH.AC_TYPE, ',') WIT...

How do I find out the sql developer version etc through code? C: \ Users \ User \ AppData \ Roaming \ SQL Developer [system3.1.07.42] [o.sqldeveloper.11.2.0.7.42] The system3.1.07.42 and o.sqldeveloper.11.2.0.7.42 folders are different depend...

Hello friends I'm trying to do a sql query in SQL Developer as follows: SELECT * FROM CLIENTE WHERE NOME_CLIENTE IN ('SALES & CIA AGUIAR', 'SAO JOAO') The tool understands the '&' character as a variable entry and so does not displa...

During the installation of SQL developer 17.3.1 on ubuntu 16.04, it did not prompt user and password. In this case I can not log in, is there any default user or some way to set up a user?     

I installed the oracle database, oracle client, and sql developer on a windows 8.1 64 bit. With the installation of the oracle database a database was created in localhost: 1521 But now I would like to create a new database on this connect...

I would like some help. I have the following query below, however, I need in the column DE to bring only the texts after the word "Exclusion", and in column PARA only bring the text from the word "Inclusion". However, today, he is bringing the w...