GV$INDEXED_FIXED_COLUMN

select
c.inst_id,               -- INST_ID NUMBER
kqftanam,                -- TABLE_NAME VARCHAR2(30)
kqfcoidx,                -- INDEX_NUMBER NUMBER
kqfconam,                -- COLUMN_NAME VARCHAR2(30)
kqfcoipo                 -- COLUMN_POSITION NUMBER
from
x$kqfco c,
x$kqfta t 
where
t.indx = c.kqfcotab and kqfcoidx != 0
home |  up  |  mailbox