Oracle deals with Null values using the NVL function. The function replaces the NULL value in the given column with the value provided to it. The function accepts two parameters, the first one is the column name and the second one is the value with which NULL has to be replaced.
Example
Sql> select nvl(comm,0) from emp;
