Question: why nvl is used in oracle?
Answer: In Oracle, the NVL function allows you to replace a NULL value with another value. It's helpful when you want to store the fact that there is no data for a particular column, but you want to display something else.