Defining an Oracle Database Instance

Question

Besides querying tables v_ $ database and v_ $ instances (or v $ instance, v $ database views), is there any other way to programmatically retrieve (from PL / SQL) the name of the oracle database database?

Answer 1

The following were found in the expert market:

select ora_database_name from dual;
select sys_context('userenv','db_name') from dual;
select global_name from global_name;

http://www.experts-exchange.com/Databases/Oracle/Q_20529577.html

Answer 2

dbms_standard.database_name