Ameer Khan

Ameer Khan

How to set username and instance name at SQL prompt

[oracle@server1 ~]$ sqlplus /  as sysdba
SQL> SET SQLPROMPT “_USER @ _CONNECT_IDENTIFIER> “
SYS @ prim> select instance_name from v$instance;
INSTANCE_NAME
—————-
prim

Categories

Leave a Reply

Your email address will not be published. Required fields are marked *