Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: suppress the output of SQL's by spooling

Re: suppress the output of SQL's by spooling

From: Andrei Romazanov <ierdna_at_web.de>
Date: Wed, 30 Apr 2003 13:52:24 +0200
Message-ID: <b8oddl$c7po0$1@ID-70985.news.dfncis.de>


?????

SQL> spool a.lst
SQL> set echo off
SQL> select 'aaa' from dual;

'AA

---
aaa

SQL> spool off

In a.lst:

SQL> set echo off
SQL> select 'aaa' from dual;

'AA
---
aaa

SQL> spool off

:-(((

"rs" <info_at_bytelife.com> schrieb im Newsbeitrag
news:3eafb184$0$89805$1b62eedf_at_news.euronet.nl...

> set echo OFF !!
> set termout off also does not display the data
>
>
> Andrei Romazanov <ierdna_at_web.de> schreef
> > Hello all,
> >
> > sorry for a naive question: how can I suppress the output of SQL's by
> > spooling?
> > I would like to have only the data.
> >
> > Thank you in advance
> > Andrei
>
>
Received on Wed Apr 30 2003 - 06:52:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US