| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
ALL_IND_EXPRESSIONS describes the expressions of function-based indexes on tables accessible to the current user.
DBA_IND_EXPRESSIONS describes the expressions of all function-based indexes in the database.
USER_IND_EXPRESSIONS describes the expressions of function-based indexes on tables owned by the current user. This view does not display the INDEX_OWNER or TABLE_OWNER columns.
| Column | Datatype | NULL | Description |
|---|---|---|---|
INDEX_OWNER |
VARCHAR2(30) |
NOT NULL |
Index owner |
INDEX_NAME |
VARCHAR2(30) |
NOT NULL |
Index name |
TABLE_OWNER |
VARCHAR2(30) |
NOT NULL |
Table or cluster owner |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Table or cluster name |
COLUMN_EXPRESSION |
LONG |
Function-based index expression defining the column | |
COLUMN_POSITION |
NUMBER |
NOT NULL |
Position of column or attribute within index |
|
 Copyright © 2002, 2003, Oracle Corporation All Rights Reserved. |
|
