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

_CONNECT_IDENTIFIER

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

&_user is substitued with the value of the user (10g)
In Oracle 10g, the sqlprompt can dynamically be set at runtime.