Re: 'set termout off' and 'set termout on'

From: <sigdock_at_my-deja.com>
Date: 2000/06/28
Message-ID: <8jcbrk$r19$1@nnrp1.deja.com>#1/1

You can use the TERMOUT OFF and TERMOUT ON statemants for switching on and off the output to the screen.

e.g.

spool out.lis
set termout off

select * from all_users;

set termout on

select name from v$database;

will only show the databasename on the screen. The file defined in the SPOOL-command will contain the information from all_users as well as the databasename.

h.t.h.

BertJan Meinders
Oracle DBA
ASR-ICT In article <8jbkp9$are$1_at_nnrp1.deja.com>, crunchy2k_at_my-deja.com wrote:
> Would someone give an example of a SQL+ query that shows where to
place
> the 'set termout off' and 'set termout on' statements?
>
> Thanks.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jun 28 2000 - 00:00:00 CDT