IS NULL |
The IS NULL operator
checks for NULL values. |
LIKE |
The LIKE operator
returns TRUE if a string matches a given mask. |
MATCHES |
The MATCHES operator
returns TRUE if a string matches a given mask. |
Equal to (==) |
The == operator
checks for equality of two expressions or for two record variables. |
Different from (!=) |
The != operator
checks for non-equality of two expressions or for two record variables. |
Lower (<) |
The < operator
is provided to test whether a value or expression is lower than another. |
Lower or equal (<=) |
The <= operator
is provided to test whether a value or expression is lower than or
equal to another. |
Greater (>) |
The > operator
is provided to test whether a value or expression is greater than
another. |
Greater or equal (>=) |
The >= operator
is provided to test whether a value or expression is greater than
or equal to another. |
NVL() |
The NVL() operator
returns the second parameter if the first argument evaluates to NULL. |
IIF() |
The IIF() operator
returns the second or third parameter according to the boolean expression
given as first argument. |