NVL2#

Functionality:#

This Oracle function will return one of two values depending upon the value of the first parameter

Parameters:#

StringValue	The variable you are working with
NotNullValue	The value you want to be returned if the variable is not NULL
NullValue	The value you want to be returned if the variable is NULL

Returns: #

String

Errors: #

None

Operations: #

If the first parameter is NOT null, then this function will return the value of the second parameter.

If the first parameter IS a null value, then this function will return the value of the third parameter.

Example:#

NVL2(~,'DMZ','No')|| will evaluate the variable passed and if it is not NULL, will return DMZ. If it is null, then it will return No

---

Notes #

Click to create a new notes page