I just noticed that the auto-correct function of the automatic code analysis rule 5816 () ignores/deletes comments.
This SQL
SELECT DECODE(n,
1, 'one', -- comment one
2, 'two', -- comment two
0) AS text
FROM DUAL;
becomes this
SELECT CASE WHEN n = 1 THEN 'one' WHEN n = 2 THEN 'two' ELSE 0 END AS text FROM DUAL;
I would find it great if the comments were included.
BR
Dirk