VIEW: SYS.ALL_XML_SCHEMA_NAMESPACES

Source

View Text - Preformatted

select s.xmldata.schema_owner OWNER,
       s.xmldata.target_namespace TARGET_NAMESPACE,
       s.xmldata.schema_url SCHEMA_URL
  from xdb.xdb$schema s, all_xml_schemas a
  where 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.TARGET_NAMESPACE TARGET_NAMESPACE
, S.XMLDATA.SCHEMA_URL SCHEMA_URL
FROM XDB.XDB$SCHEMA S
, ALL_XML_SCHEMAS A
WHERE S.XMLDATA.SCHEMA_OWNER = A.OWNER
AND S.XMLDATA.SCHEMA_URL = A.SCHEMA_URL