Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Sunday, 5 February 2017

Query to Get Database Registry listing database components in use

SELECT comp_name "Component Name"
,      comp_id   "Component ID"
,      version   "Version"
,      status    "Status"
,      namespace xonly_namespace
,      modified  "Modified"
,      schema    xonly_schema
,      procedure xonly_procedure
FROM   dba_registry
ORDER BY 1,2,3
Share this article :


  1. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check for Never Before Offers and Discount Coupon Codes.