select /*query4*/ dname from new_dept
where exists (
    select /*query4*/ b.dname, count(a.ename) as counts from new_emp a, new_dept b
    where a.deptno = b.deptno
    GROUP BY b.dname
    having count(a.ename) = 0
);

select sql_id, child_number from v$sql where sql_text like '%query4%';

SELECT * FROM table(DBMS_XPLAN.DISPLAY_CURSOR('ga2bjp9m8w1w8',0));