Hello,
I need to export the data from a table using a script in SQL Developer into a csv file , I am using SQLPLUS to do it, and it works as long the table doesn't have more than 5000 records
SET SQLFORMAT CSV
SET COLSEP ','
SPOOL c:\temp\MyTable.csv
SELECT col1,',', col2 FROM MyTable_CODE;
SPOOL OFF
I can increase the maximum of number of rows in Tools>Preferences>Database>worksheet Parameters, so I can export for example 10000 rows, but if I keep increasing that number the spool functionality just doesn't work. My table has almost 400.000 records, so if I set the worksheet parameters to 400.000 then I get the following when I run my SQLPLUS code
line 3: SQLPLUS Command Skipped: SET SQLFORMAT csv
line 4: SQLPLUS Command Skipped: SET COLSEP ','
Any ideas how to make this work with unlimited number of records?