SQL> select name, db_unique_name from v$database;
NAME DB_UNIQUE_NAME
--------- ------------------------------
ORCL orcl
SQL> select instance from v$thread;
INSTANCE
--------------------------------------------------------------------------------
orcl