select s.xmldata.schema_owner OWNER,
s.xmldata.schema_url SCHEMA_URL,
s.xmldata.target_namespace TARGET_NAMESPACE,
st.xmldata.name SIMPLE_TYPE_NAME,
value(st) SIMPLE_TYPE
from xdb.xdb$schema s, xdb.xdb$simple_type st
where sys_op_r2o(st.xmldata.parent_schema) = s.sys_nc_oid$
SELECT S.XMLDATA.SCHEMA_OWNER OWNER
,
S.XMLDATA.SCHEMA_URL SCHEMA_URL
,
S.XMLDATA.TARGET_NAMESPACE TARGET_NAMESPACE
,
ST.XMLDATA.NAME SIMPLE_TYPE_NAME
,
VALUE(ST) SIMPLE_TYPE
FROM XDB.XDB$SCHEMA S
, XDB.XDB$SIMPLE_TYPE ST
WHERE SYS_OP_R2O(ST.XMLDATA.PARENT_SCHEMA) = S.SYS_NC_OID$
|
|
|