eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: SYS.KU$_TABLE_XMLSCHEMA_VIEW

Source

View Text - Preformatted


select opq.obj# tabobj_num, opq.schemaoid schemaoid, opq.schemaoid par_oid
  from sys.opqtype$ opq
 UNION
  select opq.obj# tabobj_num, sd.dep_schema_oid schemaoid, opq.schemaoid par_oid
  from sys.opqtype$ opq, dba_xml_schema_dependency sd
  start with
    sd.schema_oid=opq.schemaoid and opq.type=1 and opq.schemaoid is not null
  connect by nocycle
    prior sd.dep_schema_oid=sd.schema_oid and
    prior opq.schemaoid=opq.schemaoid and opq.type=1

View Text - HTML Formatted

SELECT OPQ.OBJ# TABOBJ_NUM
, OPQ.SCHEMAOID SCHEMAOID
, OPQ.SCHEMAOID PAR_OID
FROM SYS.OPQTYPE$ OPQ UNION SELECT OPQ.OBJ# TABOBJ_NUM
, SD.DEP_SCHEMA_OID SCHEMAOID
, OPQ.SCHEMAOID PAR_OID
FROM SYS.OPQTYPE$ OPQ
, DBA_XML_SCHEMA_DEPENDENCY SD START WITH SD.SCHEMA_OID=OPQ.SCHEMAOID
AND OPQ.TYPE=1
AND OPQ.SCHEMAOID IS NOT NULL CONNECT BY NOCYCLE PRIOR SD.DEP_SCHEMA_OID=SD.SCHEMA_OID AND PRIOR OPQ.SCHEMAOID=OPQ.SCHEMAOID
AND OPQ.TYPE=1