You are html tracking Visitor

Wednesday, January 20, 2010

Know Instance Name

Know 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;

2 comments:

Anonymous said...

select instance_name from v$instance;

phani said...

Yeah there are many ways to find-these information. The above is one way.

Thanks,
Phani