Re: suppress the output of SQL's by spooling

Following up on Andrei Romazanov, 30 Apr 2003:

> ?????
>
> SQL> set pages 0
> SQL> spool b.lst
> SQL> select 'aaa' from dual;
> aaa
>
> SQL> spool off
>
> In b.lst:
>
> SQL> select 'aaa' from dual;
> aaa
>
> SQL> spool off
>

Ah, you want to get rid of the "SQL>" stuff?

set sqlprompt ''
should do the trick.

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam