Purpose
The USER_IND_EXPRESSIONS view displays 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 the MySQL mode.
Related views
DBA_IND_EXPRESSIONSALL_IND_EXPRESSIONS
Columns
| Column | 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. |