know the Instance Name of oracle apps

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

SELECT UPPER(sys_context(‘USERENV’,’DB_NAME’)) “Instance”
select instance_name from v$instance;

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *