ALL_OPANCILLARY

Previous Next JavaScript must be enabled to correctly display this content

2.232 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

See Also:

"DBA_OPANCILLARY"
"USER_OPANCILLARY"