Name
CREATE/ALTER/DROP OPERATOR
Synopsis
CREATE Syntax:
CREATE OPERAT0R [schema
.]operator
BINDING (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
.]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 ...
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.