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 15:10:45 +0200
Message-ID: <b8oi0h$c1sgt$1@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;

>
> set sqlprompt ''
> should do the trick.
Received on Wed Apr 30 2003 - 08:10:45 CDT

Original text of this message

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