The ALL_IND_COLUMNS view provides information about columns included in indexes on the tables accessible by the current user.

index_ownerTEXTUser name of the index owner.
schema_nameTEXTName of the schema in which the index belongs.
index_nameTEXTName of the index.
table_ownerTEXTUser name of the table owner.
table_nameTEXTName of the table to which the index belongs.
column_nameTEXTName of the column.
column_positionSMALLINTPosition of the column in the index.
column_lengthSMALLINTLength of the column in bytes.
char_lengthNUMERICLength of the column in characters.
descendCHARACTER(1)Always set to Y (descending). Included only for compatibility.