Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
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
, AND
, or 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.
LNNVL(condition)
An expression constructed using any scalar values. Note that you cannot specify an expression that contains AND, OR, or BETWEEN.