VIEW: SYS.DBA_REGISTRY_HIERARCHY

Source

View Text - Preformatted

SELECT namespace, LPAD(' ',2*(LEVEL-1)) || LEVEL || ' ' || cid, version,
       SUBSTR(dbms_registry.status_name(status),1,11),
       TO_CHAR(modified,'DD-MON-YYYY HH24:MI:SS')
FROM registry$
START WITH pid IS NULL
CONNECT BY PRIOR cid = pid and PRIOR namespace = namespace

View Text - HTML Formatted

SELECT NAMESPACE
, LPAD(' '
, 2*(LEVEL-1)) || LEVEL || ' ' || CID
, VERSION
, SUBSTR(DBMS_REGISTRY.STATUS_NAME(STATUS)
, 1
, 11)
, TO_CHAR(MODIFIED
, 'DD-MON-YYYY HH24:MI:SS') FROM REGISTRY$ START WITH PID IS NULL CONNECT BY PRIOR CID = PID
AND PRIOR NAMESPACE = NAMESPACE