../E40402-16.epub /> ../E40402-16.mobi />

ALL_INDEXTYPE_OPERATORS

ALL_INDEXTYPE_OPERATORS lists all operators supported by indextypes accessible to the current user.

Related Views

  • 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