Oracle in a Nutshell

Name

CREATE/ALTER/DROP OPERATOR

Synopsis

CREATE Syntax:

CREATE OPERAT0R [schema.] operator 
BINDING ( parameter_type [, parameter_type]... ) 
RETURN return_type 
  {[ANCILLARY TO 
    primary_operator ( parameter_type [, parameter_type]... ) 
   [, primary_operator ( parameter_type [, parameter_type]... )]...]
  | WITH INDEX CONTEXT, SCAN CONTEXT implementation_type
    [COMPUTE ANCILLARY DATA]
  }
  USING [schema .] [ package . | type . ] function_name]...

ALTER Syntax:

ALTER OPERATOR [schema.] operator  COMPILE

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 ...