Re: SQLPLUS set termout off

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Thu, 08 May 2003 03:28:06 GMT
Message-ID: <a9kua.5452$rY3.1298@news02.roc.ny.frontiernet.net>

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.48690_at_nwrdny02.gnilink.net...


> 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.

>

>

Received on Wed May 07 2003 - 22:28:06 CDT