Follow us: Subscribe via RSS Feed 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 :

0 comments:

Post a Comment