SELECT UPPER(sys_context(‘USERENV’,’DB_NAME’)) “Instance”
FROM DUAL;
or
select instance_name from v$instance;
Following Query can be used to know the Instance Name you are working from the Backend.
Latest Posts
- R12 – How to Delete Oracle AR TransactionsMarch 22, 2019 - 8:37 pm
- How to Define Custom Key Flexfield (KFF) in R12January 19, 2018 - 5:43 pm
- AutoLock Box Concepts In R12November 10, 2017 - 8:30 am
- R12 – java.sql.SQLException: Invalid column type in OAFSeptember 15, 2017 - 9:39 am
- How to Find Duplicate Row in OAF Page?April 26, 2017 - 5:17 pm
Recent Comments