Difference between NVL, NVL2 and NULLIF

Question Posted / sushma s

1 Answers
35564 Views
CTS, Metric Stream, I also Faced
E-Mail Answers

Difference between NVL, NVL2 and NULLIF..

Answer / sushma s

NVL function substitute a value when a null value is
encountered.
NVL2: substitutes a value when a null value is encountered
as well as when a non-null value is encountered.

The syntax for the NVL2 function is:

NVL2( string1, value_if_NOT_null, value_if_null )

string1 is the string to test for a null value.

value_if_NOT_null is the value returned if string1 is not null.

value_if_null is the value returned if string1 is null.

NULLIF: NULLIF function compares expr1 and expr2. If expr1
and expr2 are equal, the NULLIF function returns NULL.
Otherwise, it returns expr1.

Is This Answer Correct ?

64 Yes

2 No

Post New Answer