Re: suppress the output of SQL's by spooling

From: Andrei Romazanov <ierdna_at_web.de>
Date: Wed, 30 Apr 2003 13:55:38 +0200
Message-ID: <b8odjn$c7mo4$1@ID-70985.news.dfncis.de>

?????

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

"Noons" <wizofoz2k_at_yahoo.com.au.nospam> schrieb im Newsbeitrag news:Xns936DDA050E028Tokenthis_at_210.49.20.254...
> Following up on Andrei Romazanov, 30 Apr 2003:
>
>
> > sorry for a naive question: how can I suppress the output of SQL's by
> > spooling?
> > I would like to have only the data.
>
> Easiest way to turn off all SQL*Plus formatting
> is to use
> set pages 0
>
>
> --
> Cheers
> Nuno Souto
> wizofoz2k_at_yahoo.com.au.nospam
Received on Wed Apr 30 2003 - 06:55:38 CDT