[oracle@server1 ~]$ sqlplus / as sysdba
SQL> SET SQLPROMPT "_USER @ _CONNECT_IDENTIFIER> "
SYS @ prim> select instance_name from v$instance;
INSTANCE_NAME
----------------
prim
SQL> SET SQLPROMPT "_USER @ _CONNECT_IDENTIFIER> "
SYS @ prim> select instance_name from v$instance;
INSTANCE_NAME
----------------
prim
No comments:
Post a Comment