Feature
USER_IND_EXPRESSIONS describes function-based indexes owned by 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
ALL_IND_EXPRESSIONS
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| INDEX_NAME | VARCHAR2(128) | NO | The name of 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. |