| SQL Plus 8.0 [message #70854] |
Tue, 30 July 2002 06:35  |
Yasin Mustafa
Messages: 1
Registered: July 2002
|
Junior Member |
|
|
I have configured my SQL Plus so that whenever I log onto a new session my SQL Prompt gets set to the host name of the database.
I did this by editing the file: C:orantPLUS80GLogin.sql
I used the set command to set the sql prompt on every login.
My question is this: How can I perform a similar automated action when switching databases from within a SQL Plus session, i.e. using the command: connect username/password@host_name
Thank you.
|
|
|
|
| Re: SQL Plus 8.0 [message #70855 is a reply to message #70854] |
Tue, 30 July 2002 07:51  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
its is not directly possible to change the prompt dynamically when u use connect statement.
u may save the commands( set sqlprompt etc...) as .sql file and execute it after you have connect to the database/schema
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
