Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL PLUS
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.deReceived on Fri May 14 2004 - 14:06:26 CDT