--楼主自己拼接一下就可以了
select index_name,index_type, MAX(INDEXSTR) as column_name from
(
select a.index_name,decode(b.index_type,'BITMAP','BITMAP',' ') as index_type , wm_concat(column_name) over(partition by a.index_name order by column_position ) INDEXSTR
from user_ind_columns a,user_indexes b where a.INDEX_NAME=b.INDEX_NAME and a.TABLE_NAME = b.TABLE_NAME
and not exists(select 1 from all_indexes where index_name=a.index_name
and instr(index_type,'FUNCTION')>0)
)
group by index_name,index_type