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