Summary
The command to tell what instance one is connected to in sqlplus
Question
How can I tell what Oracle instance I am connected to in sqlplus?
Answer
After signing into Oracle's sqlplus, the command is as follows :
select instance_name from v$instance
Here is an example :
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
QDB
SQL>