turtle

NVL SELECT NVL(NULL,'want') from dual; NVL2 SELECT NVL2('not','one','two') from dual UNION ALL SELECT NVL2(NULL,'one','two') from dual;