select coalesce(null,null,4,3) coalesce from dual;
coalesce -------- 4
select coalesce(null,null,null) coalesce from dual; coalesce -------- null