| René Nyffenegger's collection of things on the web | |
|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
set sqlprompt [SQL*Plus] | ||
|
Sets the prompt for sqlplus
_CONNECT_IDENTIFIERset sqlprompt '&_CONNECT_IDENTIFIER > '
The prompt will then show what database you're connected to. However, if you change the connection using connect, this will not change
the prompt.
_user
&_user is substitued with the value of the user (10g)
In Oracle 10g, the sqlprompt can dynamically be set at runtime.
|