Other than querying the v_$database and v_$instance tables (or the views v$instance, v$database) is there any other way to programtically retrieve (from PL/SQL) the database name of an oracle database?
+4
A:
Found the following on Experts Exchange:
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
Jeff
2009-04-03 18:48:21
+1, good additional info.
DCookie
2009-04-03 20:35:29