|Oracle® OLAP DML Reference
11g Release 2 (11.2)
Part Number E17122-05
The LNNVL function provides a concise way to evaluate a condition when one or both operands of the condition may be null. LNNVL can be used anywhere a scalar expression can appear, even in contexts where the
IS [NOT] NULL,
OR conditions are not valid but would otherwise be required to account for potential nulls.
TRUE if the condition is false or unknown and
FALSE if the condition is true.
An expression constructed using any scalar values. Note that you cannot specify an expression that contains AND, OR, or BETWEEN.