2.170 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(128)

NOT NULL

Owner of the index

INDEX_NAME

VARCHAR2(128)

NOT NULL

Name of the index

TABLE_OWNER

VARCHAR2(128)

NOT NULL

Owner of the table or cluster

TABLE_NAME

VARCHAR2(128)

NOT NULL

Name of the table or cluster

COLUMN_EXPRESSION

LONG

Function-based index expression defining the column

COLUMN_POSITION

NUMBER

NOT NULL

Position of the column or attribute within the index