Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement