DBA Data[Home] [Help]

VIEW: SYS.KU$_IND_SUBPART_COL_VIEW

Source

View Text - Preformatted

select sc.obj#, sc.intcol#, value(c), sc.pos#, sc.spare1
  from ku$_simple_col_view c, ind$ i, subpartcol$ sc
  where  sc.obj#=i.obj#
  and    i.bo#=c.obj_num
  and    sc.intcol#=c.intcol_num
View Text - HTML Formatted

SELECT SC.OBJ#
, SC.INTCOL#
, VALUE(C)
, SC.POS#
, SC.SPARE1
FROM KU$_SIMPLE_COL_VIEW C
, IND$ I
, SUBPARTCOL$ SC
WHERE SC.OBJ#=I.OBJ#
AND I.BO#=C.OBJ_NUM
AND SC.INTCOL#=C.INTCOL_NUM