 |
|
Oracle Tips by Burleson |
dba operator
views
DBA_OPANCILLARY
All ancillary operators
------------------------------------------------------------------------------------
OWNER VARCHAR2 Owner of ancillary operator
OPERATOR_NAME VARCHAR2 Name of ancillary operator
BINDING# NUMBER Binding number of ancillary operator
PRIMOP_OWNER VARCHAR2 Owner of primary operator
PRIMOP_NAME VARCHAR2 Name of primary operator
PRIMOP_BIND# NUMBER Binding number of primary operator
DBA_OPARGUMENTS
All operator arguments
------------------------------------------------------------------------------------
OWNER VARCHAR2 Owner of the operator
OPERATOR_NAME VARCHAR2 Name of the operator
BINDING# NUMBER Binding# of the operator
POSITION NUMBER Position of the operator argument
ARGUMENT_TYPE VARCHAR2 Datatype of the operator argument
DBA_OPBINDINGS
All operator binding functiosn or methods
------------------------------------------------------------------------------------
OWNER VARCHAR2 Owner of the operator
OPERATOR_NAME VARCHAR2 Name of the operator
BINDING# NUMBER Binding# of the operator
FUNCTION_NAME VARCHAR2 Name of the binding function or method as specified by the user
RETURN_SCHEMA VARCHAR2 Name of the schema of the return type - not null only for ADTs
RETURN_TYPE VARCHAR2 Name of the return type
IMPLEMENTATION_TYPE_SCHEMA VARCHAR2 Schema of the implementation type of the indextype
IMPLEMENTATION_TYPE VARCHAR2 Implementation type of the indextype
PROPERTY VARCHAR2 Property of the operator binding
DBA_OPERATORS
All operators
------------------------------------------------------------------------------------
OWNER VARCHAR2 Owner of the operator
OPERATOR_NAME VARCHAR2 Name of the operator
NUMBER_OF_BINDS NUMBER Number of bindings associated with the operator
DBA_OPERATOR_COMMENTS
Comments for user-defined operators
------------------------------------------------------------------------------------
OWNER VARCHAR2 Owner of the user-defined operator
OPERATOR_NAME VARCHAR2 Name of the user-defined operator
COMMENTS VARCHAR2 Comment for the user-defined operator
|
