PL/SQL Operators

OperatorsArithmetic operators description
+Addition
Subtraction
*Multiplication
/Division
||Concatenation
**Exponentiation
OperatorsComparison operators description
=Equal to
!= , <>Not equal to
>Greater Than
>=Greater Than or Equal To
<Less Than
<=Less Than or Equal to
IS NULLReturn TRUE if its operand is null or FALSE if it is not null.
LIKEReturn TRUE if the patterns match or FALSE if they do not match.
BETWEENCheck whether a value is in a specified range.
INCompare the value to be equal to any value.
NOT INCompare the value not to be equal with certain values.
OperatorsLogical operators description
ANDDisplays records if all operands are true.
ORDisplays records if at least one operand is true.
NOTDisplays records if the condition return false.
OperatorsOther operators description
@Remote connection
:=Assignment
..Range
;Statement terminator