VIEW: SYS.KU$_INDEX_COL_VIEW

Source

View Text - Preformatted

select ic.obj#, ic.bo#, ic.intcol#,
          value(c), ic.pos#,
          ic.segcol#, ic.segcollength, ic.offset, ic.spare1,
          ic.spare2, ic.spare3, ic.spare4, ic.spare5, to_char(ic.spare6,'YYYY/MM/DD HH24:MI:SS'),
          decode(bitand(c.property,1024+2),0,0,2,1,1024,2,0)
  from ku$_simple_col_view c, ind$ i, icol$ ic
  where ic.bo#     = c.obj_num
  and   i.obj# = ic.obj#
  and c.intcol_num =
   case
      /* join index : 0x0400 */
    when (bitand(i.property, 1024) = 1024) then ic.spare2
     /* not a join index */
     /* Is this a functional index on an XMLTYPE column? */
    when (bitand(i.property, 16) = 16) then
      dbms_metadata.get_index_intcol(ic.bo#, ic.intcol#)
    else
      ic.intcol#
   end

View Text - HTML Formatted

SELECT IC.OBJ#
, IC.BO#
, IC.INTCOL#
, VALUE(C)
, IC.POS#
, IC.SEGCOL#
, IC.SEGCOLLENGTH
, IC.OFFSET
, IC.SPARE1
, IC.SPARE2
, IC.SPARE3
, IC.SPARE4
, IC.SPARE5
, TO_CHAR(IC.SPARE6
, 'YYYY/MM/DD HH24:MI:SS')
, DECODE(BITAND(C.PROPERTY
, 1024+2)
, 0
, 0
, 2
, 1
, 1024
, 2
, 0)
FROM KU$_SIMPLE_COL_VIEW C
, IND$ I
, ICOL$ IC
WHERE IC.BO# = C.OBJ_NUM
AND I.OBJ# = IC.OBJ#
AND C.INTCOL_NUM = CASE /* JOIN INDEX : 0X0400 */ WHEN (BITAND(I.PROPERTY
, 1024) = 1024) THEN IC.SPARE2 /* NOT A JOIN INDEX */ /* IS THIS A FUNCTIONAL INDEX ON AN XMLTYPE COLUMN? */ WHEN (BITAND(I.PROPERTY
, 16) = 16) THEN DBMS_METADATA.GET_INDEX_INTCOL(IC.BO#
, IC.INTCOL#) ELSE IC.INTCOL# END