Top "Oracle-sqldeveloper" questions

Oracle SQL Developer is a free and fully supported graphical tool for Oracle database development.

Does SQLDeveloper have a tool to copy/clone users like Toad?

Does SQLDeveloper have a Toad-like tool to copy/clone an Oracle database user? If not, I'll resort to: How to …

oracle toad oracle-sqldeveloper
SPOOL command doesnt save result in query

I'm using SQL Developer and I'm trying to save result of a query into the text file using spool command. …

sql oracle-sqldeveloper spool
Oracle CONTAINS Giving Invalid Identifier ORA-00904

So I have a webapp that takes in a string where ID elements are broken up by '-' (e.g. …

sql oracle contains oracle-sqldeveloper ora-00904
ORA-12541 TNS :no listener on 1 specific remote database, but not on others

Some context: I'm setting up an environment to run some Ruby code our Lead wrote to connect to some remote …

oracle oracle-sqldeveloper sqlplus tnsnames tns
What do you use to write and edit stored procedures in Oracle?

There are many options for editing and writing Stored Procedures in Oracle; what is the best tool for you and …

sql oracle stored-procedures oracle-sqldeveloper toad
sqldeveloper - DBMS_OUTPUT.PUT_LINE() Doesn't Work

I am trying to print the value passed to the DBMS_OUTPUT.PUT_LINE() function to the DBMS_OUTPUT screen …

plsql oracle-sqldeveloper dbms-output
How to execute more than 1 million insert queries in Oracle SQL Developer?

I have more than 1 million insert queries to be executed in Oracle SQL Developer, which takes a lot of time. …

sql oracle oracle-sqldeveloper sql-scripts
dbms_output.put_line prints nothing in SQL Developer version 18.1.0.095

My database is: Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bit The company just gave me a new desktop with …

oracle-sqldeveloper dbms-output
ORDER BY upper(...) with a UNION giving me problems

I'm having a bit of trouble figuring out why I'm having this problem. This code works exactly how it should. …

sql oracle sql-order-by oracle-sqldeveloper union-all
SqlDeveloper: clear network alias list

I use sql-developer to connect to several different oracle databases with several different users. The connection info is kept in …

oracle oracle-sqldeveloper tnsnames