|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
set sqlprompt [SQL*Plus]
Sets the prompt for sqlplus
set 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 is substitued with the value of the user (10g)
In Oracle 10g, the sqlprompt can dynamically be set at runtime.