To check the details for function-based indexes on a table, you may use a query similar to this:

To check the details for function-based indexes on a table, you may use a query similar to this:

select table_name,index_name,column_expression from dba_ind_expressions
where table_name= ' ' and table_owner=''
order by index_name,column_position;