select /*query1*/ 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 '%query1%';

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