Query index for a table

SQL> desc dba_ind_columns
 Name                                                              Null?    Type
 ----------------------------------------------------------------- -------- -------------------

 INDEX_OWNER                                                       NOT NULL VARCHAR2(30)
 INDEX_NAME                                                        NOT NULL VARCHAR2(30)
 TABLE_OWNER                                                       NOT NULL VARCHAR2(30)
 TABLE_NAME                                                        NOT NULL VARCHAR2(30)
 COLUMN_NAME                                                                VARCHAR2(4000)
 COLUMN_POSITION                                                   NOT NULL NUMBER
 COLUMN_LENGTH                                                     NOT NULL NUMBER
 CHAR_LENGTH                                                                NUMBER

 DESCEND                                                                    VARCHAR2(4)

SQL>select index_name, index_owner, table_name, from dba_ind_columns where index_owner='USERNAME' and table_name='TABLENAME';