PL/SQL Operators

Operators Arithmetic operators description
+ Addition
Subtraction
* Multiplication
/ Division
|| Concatenation
** Exponentiation
Operators Comparison operators description
= Equal to
!= , <> Not equal to
> Greater Than
>= Greater Than or Equal To
< Less Than
<= Less Than or Equal to
IS NULL Return TRUE if its operand is null or FALSE if it is not null.
LIKE Return TRUE if the patterns match or FALSE if they do not match.
BETWEEN Check whether a value is in a specified range.
IN Compare the value to be equal to any value.
NOT IN Compare the value not to be equal with certain values.
Operators Logical operators description
AND Displays records if all operands are true.
OR Displays records if at least one operand is true.
NOT Displays records if the condition return false.
Operators Other operators description
@ Remote connection
:= Assignment
.. Range
; Statement terminator