Read – What is Oracle NVL

Many Oracle Developers who write code in MySQL will look for this solution.

Answer 1 :- IFNULL

Answer 2 :- COALESCE ( It returns first not null expression in the list)

IFNULL

mysql> select IFNULL(null,1);
will return 1

COALESCE

mysql> select COALESCE(null,1);
will return 1

Note:- COALESCE will work in Oracle too.