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