set prompt for sql*plus

I like to have a clear command line prompt to remind me where / Who I am.

Just learn that this can be done in sqlplus also. This is use full when having mutilple instance running in one ORACLE_HOME.

the command can be addd to $ORACLE_HOME/sqlplus/admin/glogin.sql

by below command , you will have something like SYS@OCP> in your sql*plus prompt
set sqlprompt "_user'@'_user_identifier> "