NVL#

Functionality:#

This Oracle function will return a value specified if the variable you pass it is null

Parameters:#

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

Returns: #

String

Errors: #

None

Operations: #

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

If the first parameter is not a null value, then this function will return the value of the first parameter back.

Example:#

NVL(~,'N/A') will return the variable passed, or will return N/A if the variable has a NULL value

---

Notes #

Click to create a new notes page