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