| 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. |