Oracle PL/SQL Tutorial/System Tables Data Dictionary/all ind columns

Get information on all the indexes you have access to using all_ind_columns.

   <source lang="sql">

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></source>