| connect string [message #50066] |
Tue, 26 February 2002 23:53  |
Murali
Messages: 54
Registered: December 1999
|
Member |
|
|
Hi,
I want to customize the sql prompt. This should include the connect string. This will help to know to which server I have connected to.
Can anyone help me with some ideas. Is there any table or view that exists in Oracle to find connect string.
Regards,
Murali
|
|
|
|
| Re: connect string [message #50067 is a reply to message #50066] |
Wed, 27 February 2002 00:17  |
Manu Gupta
Messages: 44
Registered: January 2002
|
Member |
|
|
Dear Murli,
I also have the same type of situation. I manually change the prompt as soon as I connect to any of the server.
Command is
set sqlprompt 'abcd >'
where 'abcd >' is the name of the server to which I am connected.
|
|
|
|
| Re: connect string [message #50075 is a reply to message #50067] |
Wed, 27 February 2002 04:37 |
NB
Messages: 4
Registered: February 2002
|
Junior Member |
|
|
Set the following in your login.sql or glogin.sql files
COLUMN dbname NOPRINT new_value dbname;
SELECT name dbname FROM v$database;
SET PAUSE ON PAUSE More... PAGES 24 FEED ON
SET SQLP &dbname>>
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
