select ix.table_name,ic.index_name,ic.column_name,ic.column_position col_pos,ix.uniqueness
  from user_indexes ix ,user_ind_columns ic
  where ic.index_name = ix.index_name
  order by ix.table_name
/
col table_name format a15
col index_name fromat a18
col column_name format a15