SET SQLPROMPT in SQL* Plus

 SET SQLPROMPT command can be used to customize the SQL* Plus from the default "SQL" to any custom SQL Prompt.

Example:

 - To set the prompt to a static "DEV > " for your Development database:

SET SQLPROMPT "DEV > "

 - To display the logged in user and the name of the connected database connection alias, use the predefined variable "_USER" and "_CONNECT_IDENTIFIER" as in below:

SET SQLPROMPT "_USER'@'_CONNECT_IDENTIFIER > "

=======================================================================