• Welcome to Web Hosting Community Forum for Webmasters - Web hosting Forum.
 

Recommended Providers

Fully Managed WordPress Hosting
lc_banner_leadgen_3
Fully Managed WordPress Hosting

WordPress Theme

Divi WordPress Theme
WPZOOM

Forum Membership

Forum Membership

use of NVL function ?

Started by kavitajain9782, August 14, 2019, 04:25:24 PM

kavitajain9782

Hello Dear,

              Please Tell Me  What is the use of NVL function ?

Zolgains

Quote from: kavitajain9782 on August 14, 2019, 04:25:24 PM
Hello Dear,

              Please Tell Me  What is the use of NVL function ?
NVL function is used to replace NULL values by another value. The syntax for the NVL function is: NVL( value_in, replace_with ) value_in if the function to test on null values. The value_in field can have a datatype char, varchar2, date or number datatype. (from ORACLE documentation)