VIEW: SYS.DBA_XMLSCHEMA_LEVEL_VIEW_DUP

Source

View Text - Preformatted

select schema_url, schema_owner, schema_oid, max(level)+1, CONNECT_BY_ISCYCLE
from DBA_XML_SCHEMA_DEPENDENCY
 connect by NOCYCLE prior schema_url   = dep_schema_url   and
            prior schema_owner = dep_schema_owner and
            prior schema_oid = dep_schema_oid
 group by  schema_url, schema_owner, schema_oid, CONNECT_BY_ISCYCLE
union
select x.xmldata.schema_url, x.xmldata.schema_owner, x.sys_nc_oid$, 1, 0
from xdb.xdb$schema x
  where x.xmldata.includes is NULL and x.xmldata.imports is NULL

View Text - HTML Formatted

SELECT SCHEMA_URL
, SCHEMA_OWNER
, SCHEMA_OID
, MAX(LEVEL)+1
, CONNECT_BY_ISCYCLE FROM DBA_XML_SCHEMA_DEPENDENCY CONNECT BY NOCYCLE PRIOR SCHEMA_URL = DEP_SCHEMA_URL AND PRIOR SCHEMA_OWNER = DEP_SCHEMA_OWNER AND PRIOR SCHEMA_OID = DEP_SCHEMA_OID GROUP BY SCHEMA_URL
, SCHEMA_OWNER
, SCHEMA_OID
, CONNECT_BY_ISCYCLE UNION SELECT X.XMLDATA.SCHEMA_URL
, X.XMLDATA.SCHEMA_OWNER
, X.SYS_NC_OID$
, 1
, 0 FROM XDB.XDB$SCHEMA X
WHERE X.XMLDATA.INCLUDES IS NULL
AND X.XMLDATA.IMPORTS IS NULL