Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E25513-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_OPBINDINGS

ALL_OPBINDINGS describes the binding functions and methods on the operators accessible to the current user.

Related Views

Column Datatype NULL Description
OWNER VARCHAR2(30) NOT NULL Owner of the operator
OPERATOR_NAME VARCHAR2(30) NOT NULL Name of the operator
BINDING# NUMBER NOT NULL Binding number of the operator
FUNCTION_NAME VARCHAR2(92)   Name of the binding function or method as specified by the user
RETURN_SCHEMA VARCHAR2(30)   Name of the schema of the return type if the return type of the binding is an object type
RETURN_TYPE VARCHAR2(30)   Name of the return type
IMPLEMENTATION_TYPE_SCHEMA VARCHAR2(30)   If the operator was created WITH INDEX CONTEXT or SCAN CONTEXT, then this column displays the schema of the implementation type used by the functional implementation of the operator as a scan context (null if the operator was created without this syntax).

See Also: the CREATE OPERATOR statement in Oracle Database SQL Language Reference

IMPLEMENTATION_TYPE VARCHAR2(30)   If the operator was created WITH INDEX CONTEXT or SCAN CONTEXT, then this column displays the name of the implementation type used by the functional implementation of the operator as a scan context (null if the operator was created without this syntax).

See Also: the CREATE OPERATOR statement in Oracle Database SQL Language Reference

PROPERTY VARCHAR2(43)   Property of the operator binding:
  • WITH INDEX CONTEXT

  • COMPUTE ANCILLARY DATA

  • ANCILLARY TO

  • WITH COLUMN CONTEXT

  • WITH INDEX, COLUMN CONTEXT

  • COMPUTE ANCILLARY DATA, WITH COLUMN CONTEXT