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: Jorma Tirkkonen <Jorma.Tirkkonen_at_mail.htk.fi>
Date: 1997/03/01
Message-ID: <01bc2676$36ca1120$0bb66fc2@mruusu>#1/1

I make file d:\temp\test.sql as

set echo off
set termout off
spool d:\temp\test.txt
select * from dict;
spool off
set termout on
set echo on

and then I ran it from sqlplus like

SQL> @d:\temp\test.sql

and "termout off" don't stop spooling result to file.

(Windows NT platform and SqlPlus 3.3)

Best regards Jorma Received on Sat Mar 01 1997 - 00:00:00 CST

Original text of this message

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