Get information on all the indexes you have access to using all_ind_columns. : all_ind_columns « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. all_ind_columns

SQL>
SQL> desc all_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>
SQL> --select * from all_ind_columns;
SQL>