Name
ifnull, isnotnull — NULL-handling helper functions
Synopsis
any ifnull(
|
in expr any, |
in alt any); |
integer isnotnull(
|
in expr any); |
Description
ifnull returns expr if it is
not SQL NULL, otherwise it returns alt. This is
Virtuoso's equivalent of the SQL COALESCE expression
restricted to two arguments.
isnotnull returns 1 if its argument is not SQL NULL,
and 0 otherwise. It is the complement of
isnull.
Examples
Example 24.207. Simple Examples
SQL> select ifnull (NULL, 'fallback'), ifnull ('value', 'fallback');
SQL> select isnotnull (NULL), isnotnull ('x');