VIEW: SYS.ALL_XML_SCHEMA_SUBSTGRP_MBRS

Source

View Text - Preformatted

select s.xmldata.schema_owner OWNER,
       s.xmldata.schema_url SCHEMA_URL,
       s.xmldata.target_namespace TARGET_NAMESPACE,
       e.xmldata.property.name ELEMENT_NAME,
       value(e) ELEMENT,
       hs.xmldata.schema_owner HEAD_OWNER,
       hs.xmldata.schema_url HEAD_SCHEMA_URL,
       hs.xmldata.target_namespace HEAD_TARGET_NAMESPACE,
       he.xmldata.property.name HEAD_ELEMENT_NAME,
       value(he) HEAD_ELEMENT
  from xdb.xdb$schema s, xdb.xdb$schema hs, xdb.xdb$element e,
       xdb.xdb$element he,
all_xml_schemas a
 where sys_op_r2o(e.xmldata.property.parent_schema) = s.sys_nc_oid$
   and s.xmldata.schema_owner = a.owner
   and s.xmldata.schema_url = a.schema_url
   and e.xmldata.property.global = hexToRaw('01')
   and he.sys_nc_oid$ = sys_op_r2o(e.xmldata.HEAD_ELEM_REF)
   and sys_op_r2o(he.xmldata.property.parent_schema) = hs.sys_nc_oid$

View Text - HTML Formatted

SELECT S.XMLDATA.SCHEMA_OWNER OWNER
, S.XMLDATA.SCHEMA_URL SCHEMA_URL
, S.XMLDATA.TARGET_NAMESPACE TARGET_NAMESPACE
, E.XMLDATA.PROPERTY.NAME ELEMENT_NAME
, VALUE(E) ELEMENT
, HS.XMLDATA.SCHEMA_OWNER HEAD_OWNER
, HS.XMLDATA.SCHEMA_URL HEAD_SCHEMA_URL
, HS.XMLDATA.TARGET_NAMESPACE HEAD_TARGET_NAMESPACE
, HE.XMLDATA.PROPERTY.NAME HEAD_ELEMENT_NAME
, VALUE(HE) HEAD_ELEMENT
FROM XDB.XDB$SCHEMA S
, XDB.XDB$SCHEMA HS
, XDB.XDB$ELEMENT E
, XDB.XDB$ELEMENT HE
, ALL_XML_SCHEMAS A
WHERE SYS_OP_R2O(E.XMLDATA.PROPERTY.PARENT_SCHEMA) = S.SYS_NC_OID$
AND S.XMLDATA.SCHEMA_OWNER = A.OWNER
AND S.XMLDATA.SCHEMA_URL = A.SCHEMA_URL
AND E.XMLDATA.PROPERTY.GLOBAL = HEXTORAW('01')
AND HE.SYS_NC_OID$ = SYS_OP_R2O(E.XMLDATA.HEAD_ELEM_REF)
AND SYS_OP_R2O(HE.XMLDATA.PROPERTY.PARENT_SCHEMA) = HS.SYS_NC_OID$