SQL> column index_name format a20
SQL> column column_name format a25
SQL> column column_position format 999 heading 'POSITION'
SQL> column usq format a5
SQL> set verify off
SQL> break on index_name skip 1

select a.index_name, A.column_name,
A.column_position
from all_ind_columns A, all_indexes B
where A.table_owner = upper('&table_owner')
and A.table_name = upper('&table_name')
and A.index_owner = B.owner
and A.index_name = B.index_name
order by 2 desc,1,3
/