An operation involves either a unary operator and its single operand, or a binary operator and its two operands. The operations in an expression are evaluated in order of operator precedence.
Oracle offers the following table of operator precedence.
| Operator | Operation |
|---|---|
** |
exponentiation
|
+, - |
identity, negation
|
*, / |
multiplication, division
|
+, -, || |
addition, subtraction, concatenation
|
=, <, >, <=, >=, <>, !=, ~=, ^=, IS NULL, LIKE,BETWEEN, IN |
comparison
|
NOT |
negation
|
AND |
conjunction
|
OR |
inclusion
|
No comments:
Post a Comment