Re: SQL*Plus report output

From: Doug Coan <dcoan_at_aegonusa.com>
Date: 2000/03/27
Message-ID: <8bntp4$44q$1@nnrp1.deja.com>#1/1

In article <38DF2F8E.EE94889E_at_venis.nosp.it>, Marco Minio <m.minio_at_venis.nosp.it> wrote:
> If you don't want anything else in yout spool file then the data you
need to
> run sqlplus in silent mode
>
> sqlpus -s user/pass_at_alias @scriptfile.sql
>
> and in your scrip file you will write:
>
> set heading off
> set feedback off
> set pagesize 0
> spool spollfile
> select field from table
> /
> spool off
> exit
>
>

'set termout off' will do pretty much the same as -s

--
Doug Coan
Oracle Certified Professional DBA


Sent via Deja.com http://www.deja.com/
Before you buy.

Received on Mon Mar 27 2000 - 00:00:00 CST