From: janet <janet@telesph.com>
Subject: Re: sqlplus : How to turn off output to terminal ?
Date: 1997/03/03
Message-ID: <331AF93A.1FA9@telesph.com>#1/1
References: <aak2.857156253@Isis.MsState.Edu> <19970301130601.IAA19142@ladder02.news.aol.com>
Organization: Happy Land Sanitarium
Reply-To: janet@telesph.com
Newsgroups: comp.databases.oracle.misc



Atif Ahmad Khan <aak2@Ra.MsState.Edu> skrev i inlägg
<aak2.857156253@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