Re: suppress the output of SQL's by spooling

"Andrei Romazanov" <ierdna_at_web.de> schrieb im Newsbeitrag news:b8oi0h$c1sgt$1_at_ID-70985.news.dfncis.de...
> > > In b.lst:
> > >
> > > SQL> select 'aaa' from dual;
> > > aaa
> > >
> > > SQL> spool off
> > >
> >
> > Ah, you want to get rid of the "SQL>" stuff?
>
> no! Imean teh complett string SQL> select 'aaa' from dual;
(snip)

Hi Andrei,

what if you invoke the commands from a script like '@spooltest.sql'?

Look at this example:

1. SQL*Plus-Output : SQL*Plus: Release 8.0.6.0.0 - Production on Wed Apr 30 15:25:41 2003 (c) Copyright 1999 Oracle Corporation. All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production With the Partitioning option
JServer Release 8.1.6.2.0 - Production

15:25:42 to85e>@c:\temp\20030430\spooltest to85e>

2. Content of spooltest.sql
set pagesize 0
set trimspool on
set echo off
set heading off
set feedback off
set serveroutput off
set termout off
set time off
set timing off
ser verify off
spool c:\temp\20030430\spooltest.txt
select 'aaa' from dual;
spool off

3. Content of spooltest.txt
aaa

hth,
Guido Received on Wed Apr 30 2003 - 08:29:08 CDT