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

Parameter Type Description
index_owner TEXT The username of the owner to which the index belongs.
schema_name TEXT The name of the schema to which the index belongs.
index_name TEXT The name of the index.
table_owner TEXT The username of the owner to which the table belongs.
table_name TEXT The name of the table to which the index belongs.
column_name TEXT The name of the column.
column_position SMALLINT The position of the column within the index.
column_length SMALLINT The length of the column in bytes.
char_length NUMERIC The length of a column in characters.
descend CHARACTER(1) This parameter is supported for compatibility only. The value is Y in descending order.