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;
Subscribe to:
Post Comments (Atom)
I would like to share some of my design & development work with Oracle Applications community. I will keep adding more information to this page on ongoing basis. My blog will be most useful to those who are new to oracle technology. Do not forget giving your comments. I appreciate your comments or suggestions. This will help making blog best. Learning and Practice Oracle APPS or Oracle Cloud ERP for FREE ---> http://www.grokonline.com/vision-instance/
2 comments:
select instance_name from v$instance;
Yeah there are many ways to find-these information. The above is one way.
Thanks,
Phani
Post a Comment