How to make the query not appear in the spooled file

[DoubleH]

Hi,
I have written the following scipt:
sqlplus uname/pwd <<here
spool txt
select * from emp;
spool off;
here

Now I don't want the query to appear in the spooled file..
How could I do it?..Is there any set _____ off????
And also I would like to make the column separator as | instead of space.
Could anyone of You pls help me out???

Thanks & Regards,
DoubleH
Thanks & Regards,
DoubleH

 

[rcurva]

Basically, I use the following to download a text file without any header and feedback;

set heading off
set termout off
set verify off
set feedback off
set show off

But I think, SHOW is the one that hides the SQL command. Robbie

&quot;The rule is, not to besiege walled cities if it can possibly be avoided&quot; -- Art of War

 

[JamesCrawford]

Hi

To get a column separator to be a '|' you need to....

'SET COLSEP |'

Hope it helps

James

 

[DoubleH]

Hi,
Thanks for the reply.
But I am not able to hide the SQL stmt. Is there any way of doing it.

Thanks & Regards,
DoubleH Thanks & Regards,
DoubleH

 

[rcurva]

i got it!

SET ECHO OFF
Robbie

&quot;The rule is, not to besiege walled cities if it can possibly be avoided&quot; -- Art of War