Formatting Output

SELECT /*csv*/ * FROM scott.emp; 

SELECT /*xml*/ * FROM scott.emp; 

SELECT /*html*/ * FROM scott.emp; 

SELECT /*delimited*/ * FROM scott.emp; 

SELECT /*insert*/ * FROM scott.emp; 

SELECT /*loader*/ * FROM scott.emp; 

SELECT /*fixed*/ * FROM scott.emp; 

SELECT /*text*/ * FROM scott.emp;

SELECT /*json*/ * FROM scott.emp;

Use F5 to run (i.e. run Script rather than run Statement).

You can also use this instead of the in-line comment..

SET SQLFORMAT csv

SET SQLFORMAT

Note that you can also use this in SQLcl (but not SQL*Plus) 

Preferences

Your preferences for SQL Developer are stored in one of these locations (Windows or Linux/OSX.)...

C:\Users\%USER%\AppData\Roaming\SQL Developer

/home/%USER%/.sqldeveloper

Connections

To migrate connections from one machine to another...

• Right-click on "Connections" in "Connections" pane.

• Select Export Connections

• Transfer resultant file to new machine

• Select Import connections

• Select the connections you wish to import

• Select what you want to do about any duplicates

Layout

Bibliography