I use the default formatter settings in SQLDev plus "Line Breaks On Comma: Before":
When I format the following code
select A,
B /* multi line comment*/,
C
from T;
The result looks like this:
SELECT
a
, b /* multi line comment*/, c
FROM
t;
Based on my analysis it looks like it is not possible to control the whitespaces before a node following a multi-line comment, if no newline is defined for that node (comma in this example).
The only workaround I see is to add some pre-processing to add the newlines after the multi-line comments, re-parse and then format the code.
Thoughts?