Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Operators

 

PLSQL Operator Precedence

Operator Description **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.