The DBA_IND_COLUMNS view provides the information about all columns included in indexes on all tables in the database.

Parameter Type Description
index_owner TEXT The username of the owner to which an 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 or property name of the object column.
column_position SMALLINT The position of the column in the index.
column_length SMALLINT The length of the column. Unit: bytes.
char_length NUMERIC The length of the column. Unit: characters.
descend CHARACTER(1) This parameter is supported for compatibility only. The value is Y in descending order.