Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to remove sql statement in spool output?

vijzFeb 3 2009 — edited Feb 3 2009
Hi Gurus,

If my spool query is like this
set feedback off
set verify off
set trimspool on
set heading off

spool c:\test\test.csv
 select * FROM test;
 spool off
I am getting my csv file as like this:
SELECT * FROM test1

SSO                  
-------------------- 
shsrgh               
dehrerdh             
wtw55hd              
dhdfhdfh             
hdhdh                


SET SPOOL OFF;
What do I need to change in my SQL query such that I will not include these lines:
SELECT * FROM test1

SSO                  
-------------------- 

SET SPOOL OFF;
Thanks
This post has been answered by isotope on Feb 3 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 3 2009
Added on Feb 3 2009
17 comments
67,387 views