One of my favourite cool features in SQL Developer is the ability to turn a sql query output into an entirely different format. It doesn't even require breaking out the import/export wizard.
SPOOL C:\TEMP\foobar.csv
SELECT /*csv*/ *
FROM foo
LEFT
JOIN bar
ON foo.id = bar.id
WHERE foo.name LIKE '%HURR%';
SPOOL OFF
Complete list of formats
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;
Full details and source can be here.
Top comments (0)