Top "Oracle-sqldeveloper" questions

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

Oracle SQL Developer: Unable to find a JVM

I'm trying to open Oracle SQL Developer on my Windows7 64-bit. When I tried to open SQL Developer it asked …

java oracle-sqldeveloper
How to create a blank/empty column with SELECT query in oracle?

I want to generate an output with blank/empty column with a "Select" query in oracle. I'm able to achieve …

oracle oracle-sqldeveloper
Remove Column Header into the Output Text file

I want to create a flat file (text file) of my query from Oracle SQL Developer. I have successfully created …

oracle oracle-sqldeveloper sqlplus spool columnheader
Find the length of the longest row in a column in oracle

Does anybody know if there is a way to find what the length of the longest row in a column …

sql oracle plsql oracle-sqldeveloper
How to take a backup for the 'connection details' in sqldeveloper?

What is the process to take a backup of all the connection-details (viz. host,port,sid,etc.) in 'oracle sqldeveloper' …

backup oracle-sqldeveloper connection
Does SQLDeveloper support executing scripts?

I was trying to follow some instructions today, and it starts with the comment REM In SQLPlus I manually copy …

oracle sqlplus oracle-sqldeveloper
How to change settings for SQL Developer to correctly recognize current version of SDK

I've installed Oracle 11g r2 to my machine and when I opened Oracle SQL Developer it says: java 1.6.0_02 is not …

oracle oracle11g oracle-sqldeveloper jdk1.6
Read text file to insert data into Oracle SQL table

I am studying Oracle SQL developer. What I am doing is reading text file line by line from the folder. …

sql oracle11g oracle-sqldeveloper utl-file
Oracle SQL Developer multiple table views

In Oracle SQL Developer, one can list the data in a table using the Data tab when viewing a table. …

oracle oracle-sqldeveloper
how to run pl/sql program in oracle sql developer

DECLARE message varchar2(20):= 'Hello, World!'; BEGIN dbms_output.put_line(message); END; How can I execute above pl/sql …

plsql output oracle-sqldeveloper