Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM table(DBMS_XPLAN.DISPLAY_CURSOR('2wx1k6jq85t7p',0));
- SELECT * FROM table(DBMS_XPLAN.DISPLAY_CURSOR('bqfjy90cy8bbs',0));
- select sql_id, child_number from v$sql where sql_text like '%query5%';
- select /*query5*/ distinct dname from new_dept
- where dname = any(
- SELECT dname
- FROM new_dept
- inner JOIN new_emp ON (
- new_emp.deptno = new_dept.deptno
- )
- where new_emp.ename is null)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement