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

Pages

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 :

2 comments:

  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 https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.

    ReplyDelete
  2. Understanding the Current Set of Best Registry Cleaners. https://onohosting.com/

    ReplyDelete