Re: Connect without output

From: Radoulov, Dimitre <_at_>
Date: Wed, 18 Oct 2006 18:27:53 +0200
Message-ID: <45365607$0$49207$14726298@news.sunsite.dk>

>>> 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.

Yes,
on 8iR3 you can pass the credentials on the command line, if you don't want to get the message.

Regards
Dimitre Received on Wed Oct 18 2006 - 11:27:53 CDT