ALL_OPANCILLARY

ALL_OPANCILLARY describes operators whose bindings are ancillary to other (primary) operators.

Related Views

  • DBA_OPANCILLARY describes such information about all operators in the database.

  • USER_OPANCILLARY describes such information about operators owned by the current user.


Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Owner of the ancillary operator

OPERATOR_NAME

VARCHAR2(128)

NOT NULL

Name of the ancillary operator

BINDING#

NUMBER

NOT NULL

Binding number of the ancillary operator

PRIMOP_OWNER

VARCHAR2(128)

NOT NULL

Owner of the primary operator

PRIMOP_NAME

VARCHAR2(128)

NOT NULL

Name of the primary operator

PRIMOP_BIND#

NUMBER

NOT NULL

Binding number of the primary operator