Help: SQLPLUS set termout off

[joe bayer]

I have to run a big report. And I want to spool the result to a file, but
not to screen, to save time.

But even if I "set termout off", the result still come to my screen, what I
did was wrong?

Your help is highly appreciated.

[Anurag Varma]

termout is one of those sqlplus settings which tend to confuse quite a lot of people.

It will work if you create a sql file like this:

abc.sql:
set termout off
select 'abc' from dual

and run it like this in sqlplus:
@abc.sql

Then it won't spit the results on screen (True at least for 9i sqlplus)

if you however set termout off in sqlplus and run the query .. it still shows the results.

example:
***********************
SQL>!cat abc.sql
set termout off
select 'abc' from dual;

SQL>@abc.sql
SQL>set termout off
SQL>select 'abc' from dual;

'AB
---
abc
**********************

Anurag

"joe bayer" <joebayerii(no spam)@hotmail.com> wrote in message news:gtjua.54804$J27....@nwrdny02.gnilink.net...

[kri6d...@gmail.com]

Even this is not working i wonder why ?!!

[Mladen Gogala]

On Sat, 18 Jan 2014 08:42:20 -0800, kri6dreamy wrote:

> Even this is not working i wonder why ?!!

What is Oracle version and platform and what is the context?



--
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com