I'm trying to spool large data sets (over 200 KB) in csv format and do not need to cite the columns. This is possible via the export settings of the SQL developer GUI, but I try to do it via a SQL script. The resulting csv file is then read by another application. To demonstrate this, I run the script below.
define LINESIZE 60
put TRIMSPOOL on
set PAGESIZE 0
define SQLFORMAT csv
spool y: aa.csv
SELECT * FROM PRODUCT_COMPONENT_VERSION;
This gives the exit
"PRODUCT", "VERSION", "STATUS"
"NLSRTL", "184.108.40.206.0", "Production"
"Oracle Database 11g Enterprise Edition", "220.127.116.11.0", "64-bit Production"
"PL / SQL", "18.104.22.168.0", "Production"
"TNS for Linux:", "22.214.171.124.0", "Production"
I need the output as below (NO ROPE STRINGS)
PRODUCT, VERSION, STATUS
NLSRTL, 126.96.36.199.0, Production
Oracle Database 11g Enterprise Edition, Production 188.8.131.52.0.64bit
PL / SQL, 184.108.40.206.0, Production
TNS for Linux :, 220.127.116.11.0, Production
I would prefer not to postprocess the file (powershell, perl, etc.) after generation and before loading, because it simply adds unnecessary steps to a process.
How can I create a spool file in which I can specify the left and right speakers, even setting them to NULL.