Oracle: How to change SQL*Plus prompt to show the connected user and database?
This is an easy one, but really helpful when you are on a server with a few DB’s and you want the visual piece of mind you are not doing something on the wrong database. Add the following line on file $ORACLE_HOME/sqlplus/admin/glogin.sql That’s it, now try to access DB: