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.
Leave a Reply to mojduniya.com Cancel reply