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

PL/SQL Operator Precedence

Operator Description

Exponentiation +, - Identity, negation (unary operation)

• , /

Multiplication, division +, -, || Addition, subtraction, concatenation =, <, >, < =, > =, <>, !=, ~= IS NULL, LIKE, BETWEEN, IN Comparison NOT Logical negation AND Conjunction OR Inclusion

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.