Name
CREATE/ALTER/DROP OPERATOR
Synopsis
CREATE Syntax:
CREATE OPERAT0R [schema.]operatorBINDING (parameter_type[,parameter_type]... ) RETURNreturn_type{[ANCILLARY TOprimary_operator(parameter_type[,parameter_type]... ) [,primary_operator(parameter_type[,parameter_type]... )]...] | WITH INDEX CONTEXT, SCAN CONTEXTimplementation_type[COMPUTE ANCILLARY DATA] } USING [schema.] [ package. |type. ]function_name]...
ALTER Syntax:
ALTER OPERATOR [schema.]operatorCOMPILE
DROP Syntax:
DROP OPERATOR operator [FORCE]Creates, alters, or removes a new operator and defines its bindings. New with Oracle8i. Note that the ALTER syntax shown here is new with Oracle9i Release 2.
Keywords
- operator
Name to be assigned to this operator.
- BINDING
Specifies one or more parameter types for binding the operator to a function.
- RETURN
Specifies the return datatype of the binding.
- ANCILLARY TO
Indicates that the operator binding is ancillary to the specified primary operator binding (primary_operator).
- COMPUTE ANCILLARY DATA
Specifies that the operator binding computes ancillary data.
- function_name
Function that provides the implementation for the binding. function_name can be a standalone function, a packaged function, a type method, or a synonym for any of these.
- ALTER OPERATOR COMPILE
Specifies that the existing operator should be recompiled. New with Oracle9i Release 2.
- FORCE
Specifies that the operator is to be dropped even if it is currently being referenced by one or more schema objects ...