Friday, October 05, 2012

How to get the Instance Name

Instance Name:-
-------------------------
Following Query can be used to know the Instance Name you are working from the Backend.

SELECT UPPER(sys_context('USERENV','DB_NAME')) "Instance" FROM DUAL;


or

select instance_name from v$instance; 

No comments:

Post a Comment