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