PL/SQL Operator Precedence : Operator Precedence « PL SQL Operators « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. PL SQL Operators
  3. Operator Precedence
OperatorDescription
**Exponentiation
+, -Identity, negation (unary operation)
*, /Multiplication, division
+, -, ||Addition, subtraction, concatenation
=, <, >, < =, > =, <>, !=, ~= IS NULL, LIKE, BETWEEN, INComparison
NOTLogical negation
ANDConjunction
ORInclusion


Operations with higher precedence are applied first.

Operators with the same precedence are applied in their text order:

You can change the execution order by using parentheses.

If the expression includes parentheses, the execution starts with the innermost pair.

23.2.Operator Precedence
23.2.1.PL/SQL Operator Precedence