Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Plus report output
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
![]() |
![]() |