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 theINDEX_OWNER
orTABLE_OWNER
columns.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the index |
|
|
|
Name of the index |
|
|
|
Owner of the table or cluster |
|
|
|
Name of the table or cluster |
|
|
|
Function-based index expression defining the column |
|
|
|
Position of the column or attribute within the index |
See Also: