How do I make a silent sqlplus script?
385558Nov 6 2003 — edited Jul 9 2004I am executing a script script that looks something like this ...
sqlplus -s /nolog <<SQL
set feedback off
set serveroutput on
connect scott/tiger@testdb
declare
begin
DBMS_OUTPUT.PUT_LINE( 12 );
end;
/
SQL
the output is ...
Connected.
12
I just want to see 12. How can I stop sqlplus from outputting the Connected.
I am using SQL*Plus Release 8.1.7.0.0
Thanks!