ALL_IND_EXPRESSIONS

ALL_IND_EXPRESSIONS describes the expressions of function-based indexes on tables accessible to the current user.

Related Views

DBA_IND_EXPRESSIONS describes the expressions of all function-based indexes in the database.
USER_IND_EXPRESSIONS describes the expressions of function-based indexes on tables owned by the current user. This view does not display the INDEX_OWNER or TABLE_OWNER columns.

Column	Datatype	NULL	Description
`INDEX_OWNER`	`VARCHAR2(30)`	`NOT NULL`	Index owner
`INDEX_NAME`	`VARCHAR2(30)`	`NOT NULL`	Index name
`TABLE_OWNER`	`VARCHAR2(30)`	`NOT NULL`	Table or cluster owner
`TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Table or cluster name
`COLUMN_EXPRESSION`	`LONG`		Function-based index expression defining the column
`COLUMN_POSITION`	`NUMBER`	`NOT NULL`	Position of column or attribute within index