Suppressing all terminal output from Oracle when running an SQL query from a ksh script
Posted on 2005-03-22
I want to suppress all terminal output generated by Oracle / SQL when I run a query that resides in a ksh script. This is because this is a crontab run and everything is spooled to files anyway.
Here is a snippet from my ksh script....
sqlplus -s .......
set pagesize 0 feedback off verify off termout off showmode off heading off echo off
When I run this interactively, I still see the Oracle version and other message on the terminal. What settings should I be using ?