| SQL Plus [message #55986] |
Fri, 28 February 2003 02:19  |
Victoria
Messages: 152
Registered: July 2002
|
Senior Member |
|
|
Hi,
I am using SQL Plus in my machine to connect to remote databse.
I need to set the SQL prompt as the server name to which am connecting.
Atleast Instance name i want to be displayed as prompt.Please tell me since it gives me confusion as i am working simultaneously on 3 servers....
Please help me...
THAnks
~V~
|
|
|
|
| Re: SQL Plus [message #55988 is a reply to message #55986] |
Fri, 28 February 2003 02:55  |
Vikas Gupta
Messages: 115
Registered: February 2002
|
Senior Member |
|
|
You can add the following lines to the glogin.sql file
set termout off
col user_id new_value user_id
col user_name new_value user_name
col db_name new_value db_name
select user_id, lower(username) user_name from user_users where username = user;
select global_name db_name from global_name;
set sqlprompt "& db_name: & user_name>"
set termout on
Regards,
Vikas Gupta.
|
|
|
|
| Re: SQL Plus [message #55993 is a reply to message #55986] |
Fri, 28 February 2003 03:36 |
Victoria
Messages: 152
Registered: July 2002
|
Senior Member |
|
|
Hi,
Thanks.BUt am getting something like this.
20 att
TRN
TRN: att Mani>
Here the prompt is correctly coming.But i dont want
20 att
TRN
these two dispalys.How to avoid it???
~V~
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
