Thursday, May 2, 2024

Find Oracle DB name as a normal user

During certain situations, we may be required to find the DB name as a normal user (which does not have 'sysdba' privilege or access on v$/dba views).

In such cases, the below queries will help us with the DB name along with the domain name

select ora_database_name from dual;

select * from global_name;



No comments:

Post a Comment