SQL code folding - 10/19/07 04:23 AM
Is it possible to fold SQL code including sub query?
For example this code should folded in lines:
1,2,4,8, and 10. It will help to read/write large queries.
For example this code should folded in lines:
1,2,4,8, and 10. It will help to read/write large queries.
Code
1 SELECT 2 (SELECT COUNT(1) 3 FROM DUAL 4 WHERE EXISTS (SELECT 1 5 FROM TABLE1 T1 6 WHERE T1.FIELD1 = VAR1) 7 ) + 8 (SELECT COUNT(1) 9 FROM DUAL 10 WHERE EXISTS (SELECT 1 11 FROM TABLE2 T2 12 WHERE T2.FIELD2 = VAR2) 13 ) 14 INTO RET 15 FROM DUAL;