VIEW: SYS.ALL_XML_SCHEMA_SIMPLE_TYPES

Source

View Text - Preformatted

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, all_xml_schemas a
   where sys_op_r2o(st.xmldata.parent_schema)  = s.sys_nc_oid$ and
       s.xmldata.schema_owner = a.owner and
       s.xmldata.schema_url = a.schema_url

View Text - HTML Formatted

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
, ALL_XML_SCHEMAS A
WHERE SYS_OP_R2O(ST.XMLDATA.PARENT_SCHEMA) = S.SYS_NC_OID$ AND S.XMLDATA.SCHEMA_OWNER = A.OWNER AND S.XMLDATA.SCHEMA_URL = A.SCHEMA_URL