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(30) NOT NULL Owner of the ancillary operator
OPERATOR_NAME VARCHAR2(30) NOT NULL Name of the ancillary operator
BINDING# NUMBER NOT NULL Binding number the of ancillary operator
PRIMOP_OWNER VARCHAR2(30) NOT NULL Owner of the primary operator
PRIMOP_NAME VARCHAR2(30) NOT NULL Name of the primary operator
PRIMOP_BIND# NUMBER NOT NULL Binding number of the primary operator