Home » RDBMS Server » Networking and Gateways » how do i show current sqlnet connect string in SQL Plus?
how do i show current sqlnet connect string in SQL Plus? [message #256] Fri, 01 February 2002 05:00 Go to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 27 16:10:24 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.