Statements for Working with NA Values |
Table: Statements for Working with NA Values lists the OLAP DML statements that you use to work with NA values.
Statements for Working with NA Values
| Statement | Description |
|---|---|
| CACHE
|
Within an aggregation specification, tells Oracle OLAP whether to cache or store NA values when a summary value calculates to NA
|
| COALESCE
|
Returns the first non-NA expression in a list of expressions, or NA when all of the expressions evaluate to NA.
|
| NAFILL
|
Returns the values of the source expression with any NA values appearing as the specified fill expression.
|
| NVL
|
Replaces a NA value with a string.
|
| NVL2
|
Returns one value when the value of a specified expression is not NA, or another value when the value of the specified expression is NA.
|