Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL*Plus - Hide "Connected" response to Connect

Re: SQL*Plus - Hide "Connected" response to Connect

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Tue, 10 Aug 2004 10:52:35 -0500
Message-ID: <oprhh0lauf35cac7bcfksbaqn1grfguo70@4ax.com>


Galen Boyer <galenboyer_at_hotpop.com> wrote:

>On Tue, 10 Aug 2004, john.g_at_dot.spamfree.com wrote:
>> "Anurag Varma" <avdbi_at_hotmail.com> wrote:
>> SqlPlus -S does suppress the Connected ( an all other prompts(
>> using WXP, in DOS box - works the same with Sqlplusw.exe -S in
>> Window)
>> ------------------------------------------------------------------------------------------
>> c:\Downloads>sqlplus -S wmsreport/warehouse_at_whs1
>>
>> select * from dual;
>>
>> D - X
>> ----------------------------------------------------------------------------------------------------
>
>But, the following happens.
>
> > sqlplus -S galen/galen
> select 'A' from dual;
>
> '
> -
> A
>
> conn galen/galen
> Connected.
> select 'A' from dual;
>
> '
> -
> A
>
>From what I read, this "connected" is what the OP is looking to
>remove.

Using the Connect ( or conn) from within an existing SqlPlus session is NOT the same as using Sqlplus -S, which is what the OP asked about..

I do not believe that there is a connect -S option.. Received on Tue Aug 10 2004 - 10:52:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US