13 Difference in NVL, NVL2, Decode, Coalesce | SQL Interview Questions

Hi All,

When you encounter null in database values, NVL can be life saver as it can replace the value at runtime. There are other functions available for more complex scenarios.

1) What is NVL - NVL is a function used to replace null values at runtime.
2) What is NVL2 - NVL2 is advance function of NVL and can be used to replace value if data is not null and null respectively
3) Decode - Decode is alternative of case function and can be used to search the pattern and replace it
4) Coalesce - Coalesce function can be used to replace with any value or expression that is not null. parameter sequence from left to right

WhiteBoard Link

Github link

Web

Facebook

Instagram

Twitter

Medium

Query

#databasequery #sql #dbms