DBA Data[Home] [Help]

VIEW: SYS.KU$_FIND_SGI_COLS_VIEW

Source

View Text - Preformatted

select  i.obj#, 0, c.name
  from    col$ c, icol$ i
  where   i.bo# = c.obj# and
          i.intcol# = c.intcol#
View Text - HTML Formatted

SELECT I.OBJ#
, 0
, C.NAME
FROM COL$ C
, ICOL$ I
WHERE I.BO# = C.OBJ# AND I.INTCOL# = C.INTCOL#