doc

    Name:   i.sql

    Author: Mark Gurry

    This script lists the indexes and their columns for a selected
    table.

#

break on index_name skip 1
select index_name, column_name 
  from user_ind_columns
where table_name = upper(‘&Enter_Table_Name’)
 order by index_name, column_position
/