Advertisement
Maks140888

Untitled

Jun 2nd, 2022
990
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.41 KB | None | 0 0
  1. SELECT * FROM table(DBMS_XPLAN.DISPLAY_CURSOR('2wx1k6jq85t7p',0));
  2. SELECT * FROM table(DBMS_XPLAN.DISPLAY_CURSOR('bqfjy90cy8bbs',0));
  3. select sql_id, child_number from v$sql where sql_text like '%query5%';
  4. select /*query5*/ distinct dname from new_dept
  5. where dname = any(
  6.     SELECT dname
  7.     FROM new_dept
  8.     inner JOIN new_emp ON (
  9.     new_emp.deptno = new_dept.deptno
  10.     )
  11.     where new_emp.ename is null)
  12.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement