VIEW: SYS.KU$_OPQTYPE_VIEW

Source

View Text - Preformatted

select opq.obj#, opq.intcol#, opq.type, opq.flags, opq.lobcol,
         opq.objcol, opq.extracol, opq.schemaoid, opq.elemnum,
         decode(bitand(opq.flags,2),0,NULL,
           (select value (xe) from ku$_xmlschema_elmt_view xe
                where opq.schemaoid = xe.schemaoid
                  and opq.elemnum   = xe.elemnum))
  from sys.opqtype$ opq

View Text - HTML Formatted

SELECT OPQ.OBJ#
, OPQ.INTCOL#
, OPQ.TYPE
, OPQ.FLAGS
, OPQ.LOBCOL
, OPQ.OBJCOL
, OPQ.EXTRACOL
, OPQ.SCHEMAOID
, OPQ.ELEMNUM
, DECODE(BITAND(OPQ.FLAGS
, 2)
, 0
, NULL
, (SELECT VALUE (XE)
FROM KU$_XMLSCHEMA_ELMT_VIEW XE
WHERE OPQ.SCHEMAOID = XE.SCHEMAOID
AND OPQ.ELEMNUM = XE.ELEMNUM))
FROM SYS.OPQTYPE$ OPQ