Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Determining Oracle Database Instance

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?

like image 986
Jeff Avatar asked Dec 23 '22 12:12

Jeff


1 Answers

dbms_standard.database_name

like image 90
dpbradley Avatar answered Jan 29 '23 08:01

dpbradley