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.
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