How to set sqlplus prompt name same as Database/Instance name
We need to change one file called glogin.sql, steps are as below...
Path where glogin.sql
cd $ORACLE_HOME/sqlplus/admin
We need to change one file called glogin.sql, steps are as below...
Path where glogin.sql
cd $ORACLE_HOME/sqlplus/admin
/u01/app/oracle/product/12.1.0/dbhome_1/sqlplus/admin
set below mention line at the end of the file
vi glogin.sql
SET SQLPROMPT 'PROD-SQL>'
save and exit
Now next login you can see your db name like PROD
Thanks