Tuesday, 7 March 2017
Find database names in Oracle
Find database names in Oracle
Below select queries help us to find database names in Oracle, and also we can find the SID, service name and server host.
Oracle query command to find the database name is:
select * from global_name;
select ora_database_name from dual;
Oracle query command to check the SID (or instance name):select sys_context('userenv','instance_name') from dual;
Oracle query command to check database name (or server host):select sys_context('userenv', 'server_host') from dual;
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment