ALL_INDEXTYPE_COMMENTS displays comments for the user-defined indextypes accessible to the current user.
DBA_INDEXTYPE_COMMENTS displays comments for all user-defined indextypes in the database.
USER_INDEXTYPE_COMMENTS displays comments for the user-defined indextypes owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the user-defined indextype |
INDEXTYPE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the user-defined indextype |
COMMENTS |
VARCHAR2(4000) |
Comment for the user-defined indextype |