Nvl: nvl

Syntax

nvl ( op1 , op2 )

op1	the first operand
op2	the second operand

nvl ( ds1#m1, 0 )

The operator nvl returns op2 when op1 is null, otherwise op1.

For example:

nvl ( 5, 0 ) returns 5
nvl ( null, 0 ) returns 0

op1

dataset
| component
| scalar

op2

dataset
| component
| scalar

result

dataset
| component
| scalar

If op1 and op2 are scalar values then they must be of the same type.

If op1 and op2 are Components then they must be of the same type.

If op1 and op2 are Data Sets then they must have the same Components.

The operator nvl returns the value from op2 when the value from op1 is null, otherwise it returns the value from op1.

The operator has the typical behaviour of the operators applicable on two scalar values or Data Sets or Data Set Components.

Also the following statement gives the same result: if isnull ( op1 ) then op2 else op1.

Given the input Data Set DS_1:

Input DS_1 (see structure)

DS_r := nvl ( DS_1, 0 );

results in (see structure):