Cloned Date, Version Details, URL of Oracle Applications
Cloned date of oracle application and Version
------------------------------------
-- Query to get Version details.. --
------------------------------------
SELECT product, VERSION, status
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 backend --
-------------------------------------------------
SELECT home_url FROM icx_parameters;
Cloned date of oracle application and Version
------------------------------------
-- Query to get Version details.. --
------------------------------------
SELECT product, VERSION, status
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 backend --
-------------------------------------------------
SELECT home_url FROM icx_parameters;
No comments:
Post a Comment