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,
(select do.created from dba_objects do where di.owner=do.owner and di.index_name=do.object_name and do.object_type='INDEX') created
from
dba_indexes di,
dba_ind_columns dic
where
1=1 and
di.table_owner=dic.table_owner and
di.table_name=dic.table_name 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, (select do.created from dba_objects do where di.owner=do.owner and di.index_name=do.object_name and do.object_type='INDEX') created from dba_indexes di, dba_ind_columns dic where 1=1 and di.table_owner=dic.table_owner and di.table_name=dic.table_name and di.owner=dic.index_owner and di.index_name=dic.index_name order by dic.table_name, dic.index_name, dic.column_position