<p>EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)</p><p>DEPT (DEPTNO, DNAME, LOC)</p><p>Use NVL2 to show commission status (Has/No Commission).</p><p>(GENERAL &amp; NULL FUNCTION)</p>