OraFAQ Forum: Networking and Gateways » how do i show current sqlnet connect string in SQL Plus?

Home » RDBMS Server » Networking and Gateways » how do i show current sqlnet connect string in SQL Plus?

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

how do i show current sqlnet connect string in SQL Plus? [message #256]

Fri, 01 February 2002 05:00

Eoin McManus
Messages: 4
Registered: February 2002

Junior Member

Help....
How do i display current sqlnet connection string in SQL Plus

how....howwwww....HOWWWWWWWW???????
Thanks...Eoin

Report message to a moderator

Re: how do i show current sqlnet connect string in SQL Plus? [message #261 is a reply to message #256]

Fri, 01 February 2002 10:15

Bala
Messages: 205
Registered: November 1999

Senior Member

Hi

set sqlprompt is the command.

you would basically
SQL> COLUMN rdbms_id NEW_VALUE prompt_str NOPRINT
SQL> SELECT name || '> ' rdbms_id FROM V$DATABASE;

SQL> SET SQLPROMPT '&&prompt_str'

you can put this in a file and call this
from login.sql... so that you don't need to run this every time .....you run sql plus..

Bala.

Report message to a moderator

Previous Topic:	documentation about Oracle SQL*Connect
Next Topic:	listeners

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 16 22:43:45 CDT 2025