Question: how does nvl work in sql?
Answer: NVL(expr1, expr2) : In SQL, NVL() converts a null value to an actual value. Data types that can be used are date, character and number. Data type must match with each other i.e. expr1 and expr2 must of same data type. expr1 is the source value or expression that may contain a null.