Feature
ALL_IND_EXPRESSIONS displays information about function-based indexes accessible to the current user in the database.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
DBA_IND_EXPRESSIONS
USER_IND_EXPRESSIONS
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| INDEX_OWNER | VARCHAR2(128) | NO | The owner of the index. |
| INDEX_NAME | VARCHAR2(128) | NO | The name of the index. |
| TABLE_OWNER | VARCHAR2(128) | NO | The owner of the table containing the index. |
| TABLE_NAME | VARCHAR2(128) | NO | The name of the table containing the index. |
| COLUMN_EXPRESSION | VARCHAR2(1000) | NO | The function-based index expression. |
| COLUMN_POSITION | NUMBER(38) | NO | The position of the column within the index. |