Purpose
The DBA_IND_EXPRESSIONS view provides information about all function-based indexes in the database.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Related views
ALL_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. |