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.
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;