About
How to export a CSV with SQL Plus.
Articles Related
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: