Script : NVAL and coalesce
Oracle:
select empno, ename, NVL(hiredate, sysdate) from emp where deptno= 10
Oracle: