var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQLPLUS spool to CSV file
What is the better way that I can export data recordset to a .CSV file from Oracle SQLPLUS?
I want to output the records with comma seperated values to a .CSV file on Unix and "ftp" to a Windows2000 Desktop and open in MSEXCEL.
select * from table1.
I have to schedule this on Unix through cron job and therefore using SQLPlus command scripts to run it.
If you want to do it directly to Excel format, you could schedule an Oracle job and follow this process Using an Oracle database link to connect to Excel. Alternatively, you could schedule an Oracle job and spool to a file:
Course, you could always give Tom's unloader a shot.
SQL> select empno||','||ename from scott.emp;