CodesJava

Easy learning with example program codes

what is the use of nvl function in sql?


The nvl() function return an alternative value when an expression is NULL.
Syntax:

NVL(string, replaceWith)

Where:
string : represents the string to test for a null value.
replaeWith : represents the value returned if string is null.
Example:

SELECT NVL(cus_city, 'n/a') FROM customers;

Related topics

Posted in SQL   


Copyright © 2018 CodesJava DMCA.com Protection Status SiteMap