PL/SQL - Operators

1. Arithmetic operators
2. Relational operators
3. Comparison operators
4. Logical operators
5. String operators

Arithmetic Operators

• +
• -
• *
• /
• **

Relational Operators

• =
• !=
• <>
• ~=
• >
• <
• >=
• <=

Comparison Operators

• LIKE
• BETWEEN
• IN
• IS NULL

Logical Operators

• AND
• OR
• NOT

Operator Precedence

Operator	Operation
**	exponentiation
+, -	identity, negation
*, /	multiplication, division
+, -, ||	addition, subtraction, concatenation
=, <, >, <=, >=, <>, !=, ~=, ^=, IS NULL, LIKE, BETWEEN, IN	comparison
NOT	logical negation
AND	conjunction
OR	inclusion

Complete Tutorial