SQL Plus - Csv Export

About

How to export a CSV with SQL Plus.

Snippet

Export of the tables all_objects

set echo off
set linesize 32767
set long 90000 -- For the size of lob and long data type
set LONGCHUNKSIZE 90000; -- ColumnSize of a lob or long
set wrap off; -- A column must not go on more than one line
set heading off  
set colsep ';' 
set pagesize 0;
set feed off;
set termout off;
set trimspool on; -- No space
select * from all_objects where rownum < 10;
spool all_objects.csv
/
spool off

where:


Powered by ComboStrap