Oracle supports a number of built in operators that fall into basic categories ”simple arithmetic operators, comparison operators, logical operators, and operators that are used in select statements. In Oracle 9, support for User Defined Operators was also added. Arithmetic OperatorsTable 1-1. Arithmetic Operators
Logical OperatorsTable 1-2. Logical Operators
Comparison OperatorsTable 1-3. Comparison Operators
Select OperatorsAlso called SET operators Table 1-4. Select Operators (Sets)
Table 1-5. Other Select Operators
PrecedenceOracle evaluates expressions based on the order of precedence. Parentheses () override normal precedence. Lines are evaluated left to right for operators of equal precedence if there are no parentheses to override that order. SQL Operator Precedence
All comparison operators
Arithmetic Operator Precedence
|