home - keyword index

Keyword: OPERATOR

jump to Columns back to index

Tables

Table Name Description
ALL_INDEXTYPE_OPERATORS All operators available to the user
ALL_OPERATORS All operators available to the user
ALL_OPERATOR_COMMENTS Comments for user-defined operators
DBA_INDEXTYPE_OPERATORS All indextype operators
DBA_OPERATORS All operators
DBA_OPERATOR_COMMENTS Comments for user-defined operators
USER_INDEXTYPE_OPERATORS All user indextype operators
USER_OPERATORS All user operators
USER_OPERATOR_COMMENTS Comments for user-defined operators
top back to index

Columns

Column Name Description
NUMBER_OF_OPERATORS (ALL_INDEXTYPES) Number of operators associated with the indextype
NUMBER_OF_OPERATORS (USER_INDEXTYPES) Number of operators associated with the indextype
NUMBER_OF_OPERATORS (DBA_INDEXTYPES) Number of operators associated with the indextype
OPERATOR (ALL_MVIEW_JOINS) Name of the join operator. Currently only = is defined
OPERATOR (DBA_MVIEW_JOINS) Name of the join operator. Currently only = is defined
OPERATOR (USER_SUMMARY_JOINS) Name of the join operator. Currently only = is defined
OPERATOR (DBA_SUMMARY_JOINS) Name of the join operator. Currently only = is defined
OPERATOR (USER_MVIEW_JOINS) Name of the join operator. Currently only = is defined
OPERATOR (ALL_SUMMARY_JOINS) Name of the join operator. Currently only = is defined
OPERATOR_NAME (DBA_OPARGUMENTS) Name of the operator
OPERATOR_NAME (ALL_INDEXTYPE_OPERATORS) Name of the operator for which the indextype is defined
OPERATOR_NAME (DBA_OPANCILLARY) Name of ancillary operator
OPERATOR_NAME (USER_OPERATOR_COMMENTS) Name of the user-defined operator
OPERATOR_NAME (ALL_OPERATORS) Name of the operator
OPERATOR_NAME (DBA_INDEXTYPE_OPERATORS) Name of the operator for which the indextype is defined
OPERATOR_NAME (DBA_OPERATORS) Name of the operator
OPERATOR_NAME (ALL_OPBINDINGS) Name of the operator
OPERATOR_NAME (USER_OPARGUMENTS) Name of the operator
OPERATOR_NAME (USER_OPANCILLARY) Name of ancillary operator
OPERATOR_NAME (USER_OPERATORS) Name of the operator
OPERATOR_NAME (DBA_OPBINDINGS) Name of the operator
OPERATOR_NAME (USER_INDEXTYPE_OPERATORS) Name of the operator for which the indextype is defined
OPERATOR_NAME (DBA_OPERATOR_COMMENTS) Name of the user-defined operator
OPERATOR_NAME (ALL_OPERATOR_COMMENTS) Name of the user-defined operator
OPERATOR_NAME (ALL_OPARGUMENTS) Name of the operator
OPERATOR_NAME (ALL_OPANCILLARY) Name of ancillary operator
OPERATOR_NAME (USER_OPBINDINGS) Name of the operator
OPERATOR_SCHEMA (USER_INDEXTYPE_OPERATORS) Name of the operator schema
OPERATOR_SCHEMA (ALL_INDEXTYPE_OPERATORS) Name of the operator schema
OPERATOR_SCHEMA (DBA_INDEXTYPE_OPERATORS) Name of the operator schema
OPERATOR_TYPE (ALL_MVIEW_JOINS)
OPERATOR_TYPE (DBA_MVIEW_JOINS) Indicates inner or outer join. I = inner join, L = DETAILOBJ1 table is the left side of an outer join, R = DETAILOBJ2 table is the right side of an outer join
OPERATOR_TYPE (USER_MVIEW_JOINS)
top back to index

Comment on this page:




home - keyword index