DBA Index Columns

select
dic.table_owner,
dic.table_name,
dic.index_owner,
decode(di.index_type,'NORMAL',null,di.index_type) index_type,
dic.index_name,
xxen_util.meaning(decode(di.uniqueness,'UNIQUE','Y'),'YES_NO',0) unique_,
dic.column_name,
dic.column_position
from
dba_indexes di,
dba_ind_columns dic
where
1=1 and
di.owner=dic.index_owner and
di.index_name=dic.index_name
order by
dic.table_name,
dic.index_name,
dic.column_position

select dic.table_owner, dic.table_name, dic.index_owner, decode(di.index_type,'NORMAL',null,di.index_type) index_type, dic.index_name, xxen_util.meaning(decode(di.uniqueness,'UNIQUE','Y'),'YES_NO',0) unique_, dic.column_name, dic.column_position from dba_indexes di, dba_ind_columns dic where 1=1 and di.owner=dic.index_owner and di.index_name=dic.index_name order by dic.table_name, dic.index_name, dic.column_position