How to change the SQL prompt in SQL* Plus?? [message #19631] |
Tue, 02 April 2002 00:37 |
Sreedhar
Messages: 30 Registered: March 2000
|
Member |
|
|
Hi all,
Thank you very much for the responses for my earlier queries.
According to the suggestion I made changes in glogin.sql file so that my SQL Prompt shows my current database name as its prompt. My problem is, if I change the database by using 'connect' command, prompt is not getting changed. Please help me in this problem.
Thanks and Regards
Sreedhar
|
|
|
Re: How to change the SQL prompt in SQL* Plus?? [message #19641 is a reply to message #19631] |
Tue, 02 April 2002 07:31 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
yes.
If you use "connect" to connect to another database, the sql prompt will not work.
this is workaround, which may not be helping you.
this a sick method do it. usually i create shorcuts (sqlplus.exe ) for each database in desktop and give target as
D:OracleOra81binSQLPLUSW.EXE connect usernname/password@Host_string @p
-----
create a sql file while all the environment settings,query to get the db_name etc
and run it along the connect
---
p.sql contains the following
set sqlprompt new_db
...
...
set linesize 25
...
---
now
connect usernname/password@Host_string @p
|
|
|