select a.index_name, substr(I.uniqueness,1,1) uniq, a.column_name, a.column_position
from all_ind_columns a, all_indexes b
where a.table_owner=upper('&table_owner')
and a.index_owner=b.owner
and a.index_name=b.index_name
order by 2 desc,1,4

/