VIEW: SYS.KU$_10_2_STRMSUBCOLTYPE_VIEW

Source

View Text - Preformatted

select sct.obj#, sct.intcol#,
         o.owner_name, o.name,
         sct.toid,
         t.version#,
         sys.dbms_metadata.get_hashcode(o.owner_name,o.name),
         t.typeid
    from ku$_schemaobj_view o,type$ t, subcoltype$ sct
    where o.oid=sct.toid and o.oid=t.toid and
         NOT(o.name = 'SQL_PLAN_ALLSTAT_ROW_TYPE' and
             o.owner_name = 'SYS')

View Text - HTML Formatted

SELECT SCT.OBJ#
, SCT.INTCOL#
, O.OWNER_NAME
, O.NAME
, SCT.TOID
, T.VERSION#
, SYS.DBMS_METADATA.GET_HASHCODE(O.OWNER_NAME
, O.NAME)
, T.TYPEID
FROM KU$_SCHEMAOBJ_VIEW O
, TYPE$ T
, SUBCOLTYPE$ SCT
WHERE O.OID=SCT.TOID
AND O.OID=T.TOID AND NOT(O.NAME = 'SQL_PLAN_ALLSTAT_ROW_TYPE' AND O.OWNER_NAME = 'SYS')