ALL_OPBINDINGS

ALL_OPBINDINGS describes operator bindings accessible to the current user.

Related Views

• DBA_OPBINDINGS describes bindings of all operators in the database.
• USER_OPBINDINGS describes bindings of all operators owned by the current user.

  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)		If the return type of the binding is an object type, the schema of the type
  RETURN_TYPE	VARCHAR2(30)		Name of the return type
  IMPLEMENTATION_TYPE_SCHEMA	VARCHAR2(30)		If the operator was created WITH INDEX CONTEXT, SCAN CONTEXT, this column displays the schema of the implementation type used by the functional implementation of the operator as a scan context. (Blank if the operator was created without this syntax.) See Also: the CREATE OPERATOR statement in Oracle9i SQL Reference
  IMPLEMENTATION_TYPE	VARCHAR2(30)		If the operator was created WITH INDEX CONTEXT, SCAN CONTEXT, this column displays the name of the implementation type used by the functional implementation of the operator as a scan context. (Blank if the operator was created without this syntax.) See Also: the CREATE OPERATOR statement in Oracle9i SQL Reference