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: SQL PLUS

Re: SQL PLUS

From: Lothar Armbruester <lothar.armbruester_at_t-online.de>
Date: Fri, 14 May 2004 21:06:26 +0200
Message-ID: <PM0003DA672C13125C@hades.none.local>


Noel wrote:
>> If I save this in a file (atest.sql) and then run this from the
>> command line
>> eg: sql @atest
>> I get the input file listed out and then the results, it also
> happens
>> if it is spooled out.
>
> Try to add lines to atest.sql:
> SET FEEDBACK OFF
> SET HEADING OFF
I would rather suggest

set echo off

To stop showing the output on screen when spooling, you can use

set termout off

Hope that helps,
Lothar

-- 
Lothar Armbrüster       | la_at_oktagramm.de
Hauptstr. 26            | la_at_heptagramm.de
D-65346 Eltville        | lothar.armbruester_at_t-online.de
Received on Fri May 14 2004 - 14:06:26 CDT

Original text of this message

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