Re: Connect without output

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Wed, 18 Oct 2006 18:14:49 +0200
Message-ID: <4536533b$0$21742$9b4e6d93@newsspool3.arcor-online.net>

Radoulov, Dimitre schrieb:

>> In sqlplus, when I did connect aaa/bb_at_ccc
>> I get the message "connected"
>> How to suppress this message ?

>
> With the -S (silent mode) option:
>
> $ sqlplus -S /nolog
> connect / as sysdba
> select sysdate from dual;
>
> SYSDATE
> ---------
> 18-OCT-06
>
> exit
> $
>
>
> But it also suppresses the display of
> the SQL*Plus banner, prompts,
> and echoing of commands.
>
>
> Regards
> Dimitre
>
>

I have also noticed a version dependent differencies here. (i didn't tested 9i)
sqlplus -s aaa/bb_at_ccc don't output "Connected" in both 8iR3 and 10gR2 whereas
sqlplus -s /nolog
conn aaa/bb_at_ccc
produces "Connected" in 8iR3 and no output in 10gR2.

Best regards

Maxim Received on Wed Oct 18 2006 - 11:14:49 CDT