Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: sqlplus : How to turn off output to terminal ?

Re: sqlplus : How to turn off output to terminal ?

From: janet <janet_at_telesph.com>
Date: 1997/03/03
Message-ID: <331AF93A.1FA9@telesph.com>#1/1

Atif Ahmad Khan <aak2_at_Ra.MsState.Edu> skrev i inlägg <aak2.857156253_at_Isis.MsState.Edu>...
>
> How do I turn off output to terminal sqlplus from a select statement when I
> am spooling the result to a text file ?
 

AlexJent wrote:
>
> You can't(dont' want) to do that. The only way for data to get to the
> file there must be output from running your script.

Not my understanding.

set termout off
spool spoolfile.lst
select * ...
spool off

and your spool file contains the select data.

janet Received on Mon Mar 03 1997 - 00:00:00 CST

Original text of this message

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