Re: How to suppress output on screen in SQLPLUS?

You can route the output by doing the following :

sqlplus userid/password _at_somescript.sql > output.log

This will run on Unix without a problem.

All output will be routed to the output.log file and nothing will appear on the screen. Of course, utilize a password protection script so no one will be able to do a "ps -ef | grep sqlplus" and see your password. If you need assistance with that, just let me know.

By the way, make sure you have an exit string inside your script to exit out of the sqlplus session, otherwise, it will just sit there and then you'll have to do a kill -9 on it.

Keith D. Monton
monton_at_qni.com

badstreetboy_at_my-dejanews.com wrote in message <6uub4b$igj$1_at_nnrp1.dejanews.com>...
>I have a shell script to spool the output(generate by a select statement)
>into a file. How can I suppress the output so that it only goes into the
>file without showing up on the screen? I tried SET TERM OFF but the output
>still showed up...
>
>Thanks.
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Sep 30 1998 - 00:00:00 CEST