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

Pages

» » Query to Get Database Registry listing database components in use

Sunday, 5 February 2017

Query to Get Database Registry listing database components in use

Posted by at Labels:


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 comments:

  1. Smith10 February 2020 at 22:53

    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

Subscribe to: Post Comments (Atom)