NVL
Â
SYNTAX:
Â
FUNCTION NVL(V Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â : GENERIC : GEN1;
                            SUBSTITUTE   : GENERIC : GEN1)  :GENERIC:GEN1;
Â
The nvl function returns either the input value or an alternate value in the case where the input
has a indeterminate value.
Â
Parameters :
a) V is an expression which is of any type.
b) SUBSTITUTE is an expression which shall not evaluate to indeterminate .