ALL_IND_EXPRESSIONS
ALL_IND_EXPRESSIONS describes the expressions of function-based indexes on tables accessible to the current user.
Related Views
-
DBA_IND_EXPRESSIONSdescribes the expressions of all function-based indexes in the database. -
USER_IND_EXPRESSIONSdescribes the expressions of function-based indexes on tables owned by the current user. This view does not display theINDEX_OWNERorTABLE_OWNERcolumns.
| 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 |
See Also: