Cheeky Cockatoo

set linesize 132
set pagesize 80
break on table_name on index_name
col column_name format a30 trunc
select table_name, index_name, column_name
from dba_ind_columns
where   index_name like upper('%&Index_name%')
order by table_name, index_name, column_position
/