Changing the SQLPlus Prompt

Add an entry similar to the following entry in your glogin.sql file, found in the SQLPlus administrative directory:

set sqlprompt "_USER'@'_CONNECT_IDENTIFIER>"