spooling a csv file from a table (problems)

Hello,

[Quoted] [Quoted] I;m trying to spool the contents of a table to .csv format but when I do:

[Quoted] SQLPLUS> set heading off
[Quoted] SQLPLUS> set feedback off
SQLPLUS> spool factors.csv
SQLPLUS> select tstamp|| ',' ||pkg|| ','||prod from cfga.factors;

spool off

[Quoted] This runs fine and adds the records to the file but what happens is that the .csv file has this at the top

SQLPLUS> select tstamp|| ',' ||pkg|| ','||prod from cfga.factors;

ok, so I could VI to my file and take this out but I have huge files which vi can't cope with. There must be a spool command that ONLY writes the records to the file and not everything that you type.

so, my question is...WHAT is the command which stops the sql statement being written to the file?

Regards,
Nicholas
Chello Received on Sat Jul 21 2001 - 23:49:55 CEST