NVL Function in SQL

For Complete YouTube Video: Click Here

In this class, we will understand NVL Function.

We have already discussed the concepts of ROUND and TRUNC functions.

NVL Function in SQL

We use NVL for NULL Value Substitution.

Whenever we have NULL values in the columns, we can substitute those values with other ‘values.’

The syntax for the NVL function is as shown below.

NVL(Value, Substitution)

To understand this, we will consider the table as shown below.

In the above table, we have two null values.

The SQL command substitutes those NULL values, and the output is as shown below.