sqlplus termout out
From: Gokul <gokulkumar.gopal_at_gmail.com>
Date: Sat, 11 Apr 2009 03:52:35 -0700 (PDT)
Message-ID: <32d3edc2-9db6-45d3-a056-970611a8f6db_at_r34g2000vba.googlegroups.com>
May be a easy question. From the manuals, the "set termout off" sqlplus options suppresses the output to the terminal, but I can still see the output on the terminal. Is there anything more to it ?
Date: Sat, 11 Apr 2009 03:52:35 -0700 (PDT)
Message-ID: <32d3edc2-9db6-45d3-a056-970611a8f6db_at_r34g2000vba.googlegroups.com>
May be a easy question. From the manuals, the "set termout off" sqlplus options suppresses the output to the terminal, but I can still see the output on the terminal. Is there anything more to it ?
#!/bin/ksh
sqlplus -s AAA_owner/AAA_owner_at_AAAngrp <<EOF
set feedback off
set heading off
set termout off
spool z998.dat
select 1 from dual
union
select 2 from dual;
spool off
set termout on
quit
EOF
Rgds,
Gokul
Received on Sat Apr 11 2009 - 05:52:35 CDT