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