SQLPLUS araci ile excel çıktısı alabilmek için örnek;

set term off
set echo off
set underline off
set colsep “;”
set linesize 100
set pagesize 0
set sqlprompt ”
set lines 1000 pages 1000
set trimspool on
set feedback off
set heading on
set newpage 0
set headsep off

spool myFile.csv
select * from locations;
spool off;
exit;
/

Loading