select schm.sys_nc_oid$, extractValue(value(schm), '/schema/@x:schemaURL',
'xmlns="http://www.w3.org/2001/XMLSchema" xmlns:x="http://xmlns.oracle.com/xdb"'),
extractValue(value(xel), '/element/@x:propNumber',
'xmlns="http://www.w3.org/2001/XMLSchema" xmlns:x="http://xmlns.oracle.com/xdb"'),
case WHEN (extractValue(value(xel) , '/element/@name') is NULL)then
xel.xmldata.property.propref_name.name
else extractValue(value(xel) , '/element/@name')
end
from xdb.xdb$element xel, xdb.xdb$schema schm
where ref(schm) = extractValue(value(xel), '/element/@x:parentSchema',
'xmlns="http://www.w3.org/2001/XMLSchema" xmlns:x="http://xmlns.oracle.com/xdb"')
SELECT SCHM.SYS_NC_OID$
, EXTRACTVALUE(VALUE(SCHM)
, '/SCHEMA/@X:SCHEMAURL'
,
'XMLNS="HTTP://WWW.W3.ORG/2001/XMLSCHEMA" XMLNS:X="HTTP://XMLNS.ORACLE.COM/XDB"')
,
EXTRACTVALUE(VALUE(XEL)
, '/ELEMENT/@X:PROPNUMBER'
,
'XMLNS="HTTP://WWW.W3.ORG/2001/XMLSCHEMA" XMLNS:X="HTTP://XMLNS.ORACLE.COM/XDB"')
,
CASE WHEN (EXTRACTVALUE(VALUE(XEL)
, '/ELEMENT/@NAME') IS NULL)THEN
XEL.XMLDATA.PROPERTY.PROPREF_NAME.NAME
ELSE EXTRACTVALUE(VALUE(XEL)
, '/ELEMENT/@NAME')
END
FROM XDB.XDB$ELEMENT XEL
, XDB.XDB$SCHEMA SCHM
WHERE REF(SCHM) = EXTRACTVALUE(VALUE(XEL)
, '/ELEMENT/@X:PARENTSCHEMA'
,
'XMLNS="HTTP://WWW.W3.ORG/2001/XMLSCHEMA" XMLNS:X="HTTP://XMLNS.ORACLE.COM/XDB"')
|
|
|