Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL*Plus report output
I am spooling the output of a select statement to a file. The output gets properly sent to the file. However, the select statement is also being output to the file - it appears at the top of the file, before the actual output.
How can I suppress the code from being sent to the output file?
My code looks like this:
spool C:\Filename.txt
/* Here is my select statement */
select * from TABLENAME;
spool off
The output file looks like this:
/* Here is my select statement/
select * from TABLENAME;
row1
row2
row3
......
Received on Sun Mar 26 2000 - 00:00:00 CST