Toad World® Forums

Beta Released (12.1.0.6)

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;