In SQL*Plus, how to change the prompt to show the connected user and database?

DB Scripts

In SQL*Plus, how do I change the prompt to show the connected user and database?

Connect as oracle user and add the following line at the end of th glogin.sql script.

su – oracle
vi $ORACLE_HOME\sqlplus\admin\glogin.sql
set sqlprompt “_user ‘@’ _connect_identifier > “

Now check

sqlplus / as sysdba
SYS @ LBTCI1 >