WHat does "output of SQL's" mean? Do you mean the 'SQL>' chars? If so,
try 'set sqlprompt ""', or you can use grep to get them out of your
output.
--
Ron Reidy
Oracle DBA
Andrei Romazanov wrote:
> ?????
>
> 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 - 07:00:45 CDT
