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.