Hi,
I am trying to find out list of employees who have no dept_id.
Below code works.
select e.emp_id, e.last_name, e.dept_id
from employees E
where dept_id IS NULL
Below code does not work. i want to rewrite the query using NVL to replace the value by 0. does not work.
select e.emp_id, e.last_name, e.dept_id
from employees E
where NVL(dept_id, 0) IS NULL
Thx.