SQL Plus - Csv Export

Card Puncher Data Processing


How to export a CSV with SQL Plus.


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


Share this page:
Follow us:
Task Runner