Editor - Refactoring:
New refactoring item added to correct indentation level of where clause expressions. For example…
SELECT *
FROM emp e1
WHERE e1.empno IN (SELECT mgr
FROM emp e2
WHERE e1.deptno = 10);
…is better written as…
SELECT *
FROM emp e1
WHERE e1.empno IN (SELECT mgr
FROM emp e2)
AND e1.deptno = 10;