Thanks, Larry!

It worked well and solved my problem. All I have to do now is to get all "column_name"s for each "index_name" to get its index expression.

Regards,

Fernando

>Fernando,
>Join it with ALL_IND_COLUMNS (another view):

select a.index_name, b.* from all_indexes a, all_ind_columns b 
   where a.index_name = b.index_name and upper(a.table_name) = 'MYTABLE'

>You may have to join the two views on table_name as well if you have indexes with the same name on multiple tables.