Description:
Get the first non-null member that isn’t double quoted from an integer sequence.
Syntax:
|
A.nvl() |
Equivalent to nvl(x1,…,xn) |
Note:
The function gets the first non-null member that isn’t double quoted from integer sequence A.
Parameter:
|
A |
An integer sequence |
Return value:
A non-null an non-double-quoted member
Example:
|
|
A |
|
|
1 |
=[1,2,4].nvl() |
1 |
|
2 |
=[null,2,3,4].nvl() |
2 |
|
3 |
=["",2,3,4].nvl() |
2 |