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 report output

Re: SQL*Plus report output

From: Marco Minio <m.minio_at_venis.nosp.it>
Date: 2000/03/27
Message-ID: <38DF2F8E.EE94889E@venis.nosp.it>#1/1

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 Received on Mon Mar 27 2000 - 00:00:00 CST

Original text of this message

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