Purpose
The ALL_IND_EXPRESSIONS view provides 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 the MySQL mode.
Related views
DBA_IND_EXPRESSIONSUSER_IND_EXPRESSIONS
Columns
| Column | 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. |