OraFAQ Forum: Client Tools » sqlplus remove feedback "connected"

Home » Other » Client Tools » sqlplus remove feedback "connected"

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sqlplus remove feedback "connected" [message #203180]

Tue, 14 November 2006 03:45

laksha
Messages: 42
Registered: June 2006

Member

c:>sqlplus /nolog
SQL>conn hello/how_are@you
connected

How do i get rid of the "connected" feedback ?

Thanks.

Report message to a moderator

Re: sqlplus remove feedback "connected" [message #203191 is a reply to message #203180]

Tue, 14 November 2006 04:10

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

There's no way of ding it that I know of.

Report message to a moderator

Re: sqlplus remove feedback "connected" [message #203218 is a reply to message #203180]

Tue, 14 November 2006 06:29

pravin3032
Messages: 51
Registered: November 2006
Location: eARTH

Member

hi
Are you looking for a change in job ???

regards,
pravin

Report message to a moderator

Re: sqlplus remove feedback "connected" [message #203222 is a reply to message #203180]

Tue, 14 November 2006 06:41

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

sqlplus -silent user/pass@db

Report message to a moderator

Re: sqlplus remove feedback "connected" [message #203321 is a reply to message #203222]

Tue, 14 November 2006 15:35

ebrian
Messages: 2794
Registered: April 2006

Senior Member

tahpush wrote on Tue, 14 November 2006 07:41

sqlplus -silent user/pass@db

The problem with the silent parameter, it will suppress more than just the "Connected." value:

E:\>sqlplus -silent system/oracle
select * from dual;

D
-
X

exit

E:\>

Report message to a moderator

Re: sqlplus remove feedback "connected" [message #203370 is a reply to message #203321]

Tue, 14 November 2006 23:00

laksha
Messages: 42
Registered: June 2006

Member

Yes. I want to suppress every thing.
I used silent,termout off,echo off,feedback off.

Not getting rid of "connected".

I am using it in batch file as
sqlplus -silent /nolog @abcd.sql

where abcd.sql is
-----------------------------
connect user/pwd@database
set termout off;
update abcd set A=1 where A is null;
commit;
exit;
/
-----------------------------

I am able to suppress every thing except "connected".

Report message to a moderator

Re: sqlplus remove feedback "connected" [message #203372 is a reply to message #203370]

Tue, 14 November 2006 23:07

laksha
Messages: 42
Registered: June 2006

Member

I got it .I was using conn first and then set termout off in sql script.

Now I am doing termout off first and then connect in sql script.
It worked.

Thanks.

Report message to a moderator

Previous Topic:	how to use sql navigator
Next Topic:	How to Debug Procedure in TAOD.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 20:41:16 CST 2024