Skip to content

Instantly share code, notes, and snippets.

@wingkwong

wingkwong/fast-gen-csv-from-oracle-db.sql

Created May 14, 2020 09:59
Show Gist options
  • Save wingkwong/363f4034e023479f524ed5817cda70e0 to your computer and use it in GitHub Desktop.
Save wingkwong/363f4034e023479f524ed5817cda70e0 to your computer and use it in GitHub Desktop.
Download ZIP
Fast Generation of CSV from Oracle Database
Raw
fast-gen-csv-from-oracle-db.sql
set markup csv on
set feedback off
set termout off
spool 'EXPORTED_RESULT.csv';
SELECT * FROM FOO_TABLE;
spool off;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment