Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page