How to change SQL prompt in Oracle?
Procedure to change SQL prompt in Oracle.
Default SQL prompt:
Changing SQL promt to specific username
1. Go to ORACLE_HOME/sqlplus/admin.
Append below line in glogin.sql file.
set sqlprompt '_USER>';

2. Connect to the database. You can see the prompt as a user name in below snap.

No comments:
Post a Comment