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:09:00 +0200
Message-ID: <b8oht9$c0uag$1@ID-70985.news.dfncis.de>

"Ron Reidy" <rereidy_at_indra.com> schrieb im Newsbeitrag news:3EAFBAED.2070909_at_indra.com...
> WHat does "output of SQL's" mean? Do you mean the 'SQL>' chars?

SQL> and all that follows: f.e. SQL> select 'aaa' from dual;

with setprompt I can only get out SQL> - prompt

> If so,
> try 'set sqlprompt ""', or you can use grep to get them out of your
> output.

of course! But I thought such a simplest things must be in sqlplus direct ajustable. Received on Wed Apr 30 2003 - 08:09:00 CDT

Original text of this message

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