Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL*Plus - Hide "Connected" response to Connect
"Anurag Varma" <avdbi_at_hotmail.com> wrote:
>
>"Les Noll" <lnoll_at_netnitco.net> wrote in message news:TieRc.1817$Ow6.145236_at_newssvr28.news.prodigy.com...
>> Thanks, I didn't think about appending the separate files but that is an
>> option.
>> +Les
>> --
>>
>> ------------------------------------------------------------------------
>> Lester L. Noll
>> lesnoll_at_sbcglobal.net
>> http://freepages.genealogy.rootsweb.com/~lnoll
>> "Hans Forbrich" <forbrich_at_yahoo.net> wrote in message
>> news:tG5Rc.66002$T_6.10919_at_edtnps89...
>> > Les Noll wrote:
>> >
>> > > Thanks, Hans and Ana. Yes, I did search the manual first, and found
>> > > nothing.
>> > >
>> > > SQLPLUS -S doesn't suppress the "Connected" response.
>> > >
>> >
>> > The obvious 'hard way' is to have the output from each user go to a
>> separate
>> > file and then use an OS command to copy/append (such as unix !cat a b >>
>> c)
>> >
>> > IIRC, Thomas Kyte mentioned something about this either in one of his
>> books
>> > or at http://asktom.oracle.com - you might try asking Tom
>> >
>> > /Hans
>>
>>
>
>or maybe you can just grep the "connected" out ...
>something like this:
>
>print "
> connect user/pass
> @sqlscript
> exit;
>" | sqlplus -s /nolog | egrep -v '^Connected.$' > output.file
>
>Anurag
>
SqlPlus -S does suppress the Connected ( an all other prompts( using WXP, in DOS box - works the same with Sqlplusw.exe -S in Window)
select * from dual;
D
-
X
![]() |
![]() |