| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01  | 
  | 
  | 
View PDF | 
ALL_OPANCILLARY describes operators whose bindings are ancillary to other (primary) operators.
Related Views
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 |