Steel
Programming
+38 098 888 58 89 Alexander
s.berezovich Skype
steelprogram@gmail.com E-mail
Saving result of select into csv file
When I need fast send csv file with selecting results, I can't see better solution that sqlplus + spool
-- set name of output file
spool output.csv
-- switch off displaing time after select
set timing off
-- switch off displaying column headers
set heading off
-- set space between new page start and old page finish (line count)
-- if you have 64-bit OS (Windows 7 for example) and 32-bit database (Oracle 11 XE for example) when you
-- set newpage parameter to 0 you can found in output file character with code 255 (0xFF) in this case
-- simples way set newpage 1 and just skip empty line on loading csv file
set newpage 0
-- switch off output selecting data on screen
set termout off
-- set line size must be large or equal output string length
set linesize 1000
-- switch off blank space from end of output line to [linesize]
set trimspool off
-- switch off rows count output
set feedback off
-- there your select just concatenate all your columns in one (to remove blank space in output file)
select level || ',' ||
'Some test string' ||
to_char(sysdate - level / 10, 'DD.MM.YYYY HH24:MI:SS')
from dual connect by level < 1001;
spool off
quit
You can add comment on current page, or on forum page there.