Indexe details on a table

COLUMN index_name format A20

COLUMN column_name format A25

COLUMN column_position format 999 heading 'Pos'

COLUMN uniq format a5

SET verify off

BREAK on index_name skip 1



SELECT c.index_name, SUBSTR (i.uniqueness, 1, 1) uniq, c.column_name,
c.column_position
FROM all_ind_columns c, all_indexes i
WHERE c.table_owner = UPPER ('&table_owner')
AND c.table_name = UPPER ('&table_name')
AND c.index_owner = i.owner
AND c.index_name = i.index_name
ORDER BY 2 DESC, 1, 4
/