Design and Development > Programming

use of NVL function ?

(1/1)

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 ?

--- End quote ---
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)

Navigation

[0] Message Index

Go to full version