Hi,
Looking to spool output to a .csv file from oracle table.
How can we do this as quickly as possible.
Tried running but had line breaks between rows, column headings etc. and put output on screen.
Have seen below but not sure enough.
We just want dump of the data as a .csv file with no headings etc. and run as qucikly as possibe when we run it approx 2 million rows and nearly 100 columns.
Anyone have sample generic spool script of what need to have in it to achieve this?
Thanks
oracle version 11.2
set heading off
set feedback off
set echo off
set verify off
spool text.csv
@query.sql
spool off
Anyone have sample spool script