VIEW: SYS.KU$_10_2_STRMCOLTYPE_VIEW

Source

View Text - Preformatted

select ct.obj#, ct.col#, ct.intcol#,
         o.owner_name, o.name,
         ct.flags,
--
-- opq.flags not present in 10g
--         (select opq.flags from sys.opqtype$ opq
--          where opq.obj#=ct.obj# and opq.intcol#=ct.intcol#),
         ct.toid,
         ct.version#,
         sys.dbms_metadata.get_hashcode(o.owner_name,o.name),
         ct.typidcol#,
         /* look up stuff in subcoltype$ only if column is substitutable */
         decode(bitand(ct.flags, 512), 512,
           cast(multiset(select sct.* from ku$_10_2_strmsubcoltype_view sct
                where ct.obj#    = sct.obj_num
                and   ct.intcol# = sct.intcol_num
                       ) as ku$_strmsubcoltype_list_t
                ),
           null)
    from ku$_schemaobj_view o, obj$ oo, coltype$ ct
         where ct.toid = oo.oid$
         and o.obj_num = oo.obj#

View Text - HTML Formatted

SELECT CT.OBJ#
, CT.COL#
, CT.INTCOL#
, O.OWNER_NAME
, O.NAME
, CT.FLAGS
, -- -- OPQ.FLAGS NOT PRESENT IN 10G -- (SELECT OPQ.FLAGS
FROM SYS.OPQTYPE$ OPQ --
WHERE OPQ.OBJ#=CT.OBJ#
AND OPQ.INTCOL#=CT.INTCOL#)
, CT.TOID
, CT.VERSION#
, SYS.DBMS_METADATA.GET_HASHCODE(O.OWNER_NAME
, O.NAME)
, CT.TYPIDCOL#
, /* LOOK UP STUFF IN SUBCOLTYPE$ ONLY IF COLUMN IS SUBSTITUTABLE */ DECODE(BITAND(CT.FLAGS
, 512)
, 512
, CAST(MULTISET(SELECT SCT.*
FROM KU$_10_2_STRMSUBCOLTYPE_VIEW SCT
WHERE CT.OBJ# = SCT.OBJ_NUM
AND CT.INTCOL# = SCT.INTCOL_NUM ) AS KU$_STRMSUBCOLTYPE_LIST_T )
, NULL)
FROM KU$_SCHEMAOBJ_VIEW O
, OBJ$ OO
, COLTYPE$ CT
WHERE CT.TOID = OO.OID$
AND O.OBJ_NUM = OO.OBJ#