Re: spooling a csv file from a table (problems)

Nicholas Mudie (nmudie_at_chello.com) wrote:
: Hello,
 

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

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

: spool off
 

: 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;

There are other SET options besides the ones you use. Look them up in your sqlplus reference manual.

I think the one you want is "echo", as in "set echo off", but I have no oracle software today to confirm that. You also want to check on the options trimspool and termout and linesize, there may be others, read and learn them all.

--
Want to access the command line of your CGI account?  Need to debug your
installed CGI scripts?  Transfer and edit files right from your browser? 

What you need is "ispy.cgi" - visit http://nisoftware.com/ispy.cgi