Dear experts,

I need to spool rows from a select statement to a text file.

What parameters in SQL*PLUS should I set if I

1) do not want to see the sql> prompts in the text file

e.g.
sql> select col1, col2 from table1;

col1, col2
col1, col2

sql> spool off

2) set heading off, I get an extra line as the first line in my text file. How do I get rid of the extra line?

Any advice greatly appreciated.

Cheers,

Pete

try feedback off as well and you will see the net data only