V$INDEXED_FIXED_COLUMN definition in Oracle Database 11.2
V$INDEXED_FIXED_COLUMN

select
  TABLE_NAME,                              -- TABLE_NAME VARCHAR2(30)
  INDEX_NUMBER,                            -- INDEX_NUMBER NUMBER
  COLUMN_NAME,                             -- COLUMN_NAME VARCHAR2(30)
  COLUMN_POSITION                          -- COLUMN_POSITION NUMBER
from
  GV$INDEXED_FIXED_COLUMN
where
  inst_id = USERENV('Instance')

home |  up