VIEW: SYS.KU$_IND_COL_VIEW

Source

View Text - Preformatted

select  i.obj#, c.name, c.name, i.intcol#, i.col#, c.property,
          decode(c.property, 1056, 1, 0),
          decode(c.property , 1056,
            (select name from attrcol$ a
             where a.obj# = c.obj# AND a.intcol# = c.intcol# - 1),
             (NVL((select name from attrcol$ a
                 where a.obj# = c.obj# AND a.intcol# = c.intcol#), NULL))),
          sys.dbms_metadata_util.long2varchar(c.deflength,
                                              'SYS.COL$',
                                              'DEFAULT$',
                                              c.rowid)
  from    col$ c, icol$ i
  where   i.bo# = c.obj# and
          i.intcol# = c.intcol#

View Text - HTML Formatted

SELECT I.OBJ#
, C.NAME
, C.NAME
, I.INTCOL#
, I.COL#
, C.PROPERTY
, DECODE(C.PROPERTY
, 1056
, 1
, 0)
, DECODE(C.PROPERTY
, 1056
, (SELECT NAME
FROM ATTRCOL$ A
WHERE A.OBJ# = C.OBJ#
AND A.INTCOL# = C.INTCOL# - 1)
, (NVL((SELECT NAME
FROM ATTRCOL$ A
WHERE A.OBJ# = C.OBJ#
AND A.INTCOL# = C.INTCOL#)
, NULL)))
, SYS.DBMS_METADATA_UTIL.LONG2VARCHAR(C.DEFLENGTH
, 'SYS.COL$'
, 'DEFAULT$'
, C.ROWID)
FROM COL$ C
, ICOL$ I
WHERE I.BO# = C.OBJ# AND I.INTCOL# = C.INTCOL#