After login to Sqlplus
set sqlprompt "_user> "
It will come as SYS>
You can also see as SYS @ hrms> by setting
set sqlprompt "_user '@' _connect_identifier > "
If you want it it permanently
You have to set the same in the file $ORACLE_HOME\sqlplus\admin\glogin.sql
script
No comments:
Post a Comment