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
from xdb.xdb$schema s, xdb.xdb$element e
where sys_op_r2o(e.xmldata.property.parent_schema) = s.sys_nc_oid$
and e.xmldata.property.global = hexToRaw('01')
and ref(e) in ( select distinct se.xmldata.HEAD_ELEM_REF
from xdb.xdb$element se where
se.xmldata.HEAD_ELEM_REF is not null)
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
FROM XDB.XDB$SCHEMA S
, XDB.XDB$ELEMENT E
WHERE SYS_OP_R2O(E.XMLDATA.PROPERTY.PARENT_SCHEMA) = S.SYS_NC_OID$
AND E.XMLDATA.PROPERTY.GLOBAL = HEXTORAW('01')
AND REF(E) IN ( SELECT DISTINCT SE.XMLDATA.HEAD_ELEM_REF
FROM XDB.XDB$ELEMENT SE WHERE
SE.XMLDATA.HEAD_ELEM_REF IS NOT NULL)
|
|
|