1. Home
  2. SQL
  3. SQL Bible Oracle

User-defined Operators

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.



Preface
Part I: SQL Basic Concepts and Principles
Part II: Creating and Modifying Database Objects
Part III: Data Manipulation and Transaction Control
Part IV: Retrieving and Transforming Data
Chapter 8: Understanding SELECT Statement
Chapter 9: Multitable Queries
Chapter 10: SQL Functions
Chapter 11: SQL Operators
Arithmetic Operators
Logical Operators
Operator Precedence
Assignment Operator
Comparison Operators
Bitwise Operators
User-defined Operators
Summary
Part V: Implementing Security Using System Catalogs
Part VI: Beyond SQL--Procedural Programming and Database Access Mechanisms
Part VII: Appendix
List of Figures
List of Tables
List of Code Examples
List of Sidebars