SELECT /*query2*/dname
FROM new_Dept
LEFT JOIN new_emp ON (
new_emp.deptno = new_dept.deptno
)
where new_emp.ename is null;

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

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