ALL_OPANCILLARY describes operators whose bindings are ancillary to other (primary) operators.
DBA_OPANCILLARY provides such information about all operators in the database.
USER_OPANCILLARY provides 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 |