Monday, 15 May 2017

Query to find Cloned Date, Version Details, URL of Oracle Applications

Query to get Instance Version details

SELECT product,
FROM   product_component_version;  

Query to  get cloned date of an oracle instance

SELECT resetlogs_time
FROM   v$database; 

Query to get the front end URL from back-end

SELECT home_url
FROM   icx_parameters; 

No comments:

Post a Comment