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')