User-defined Operators

Oracle 9i allows you to create user-defined operators. They are created using the CREATE OPERATOR statement and are identified by names rather than by single characters. Once a user-defined operator is created it can be used just like any of the built-in operators with the notable exception that one has to have EXECUTE privilege to this object.

User-defined operators in Oracle 9i behave very similarly to user-defined functions, because Oracle takes sets of operands for input and returns values.