ALL_INDEXTYPE_OPERATORS lists all operators supported by indextypes accessible to the current user.
DBA_INDEXTYPE_OPERATORS lists all operators supported by indextypes in the database.
USER_INDEXTYPE_OPERATORS lists all operators supported by indextypes owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the indextype |
INDEXTYPE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the indextype |
OPERATOR_SCHEMA |
VARCHAR2(30) |
NOT NULL |
Name of the operator schema |
OPERATOR_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the operator for which the indextype is defined |
BINDING# |
NUMBER |
NOT NULL |
Binding number associated with the operator |