supress connected message

[Paul]

Hi,

I'd like to supress the "Connected." message after connecting to a db.
This is because I use a script like:

spool myoutput.txt
connect scott@mydb1/tiger
select instance_name, version from v$instance;
connect scott@mydb2/tiger
select instance_name, version from v$instance;
connect scott@mydb3/tiger
select instance_name, version from v$instance;
spool off

I don't want the lines 'Connected.' in between my output.

How to accomplish this? Thanks for any help.

[Noel]

Użytkownik alsemgeest@it4us.nl napisał:
Hi, I'd like to supress the "Connected." message after connecting to a db. This is because I use a script like: spool myoutput.txt connect scott@mydb1/tiger select instance_name, version from v$instance; connect scott@mydb2/tiger select instance_name, version from v$instance; connect scott@mydb3/tiger select instance_name, version from v$instance; spool off I don't want the lines 'Connected.' in between my output. How to accomplish this? Thanks for any help.

You could try SET TERMOUT OFF after spool command.

--
Noel

[Maxim Demenko]

Noel schrieb: Użytkownik alsemgeest@it4us.nl napisał: Hi, I'd like to supress the "Connected." message after connecting to a db. This is because I use a script like: spool myoutput.txt connect scott@mydb1/tiger select instance_name, version from v$instance; connect scott@mydb2/tiger select instance_name, version from v$instance; connect scott@mydb3/tiger select instance_name, version from v$instance; spool off I don't want the lines 'Connected.' in between my output. How to accomplish this? Thanks for any help. You could try SET TERMOUT OFF after spool command.
TERMOUT OFF doesn't suppress "connected" message if you connect from
within sqlplus. You can consider to connect from the commandline
instead, then "SILENT" option will suppress this message ( sqlplus -s
scott/tiger@mydb )

Best regards

Maxim