Greetings,
I’ve been running SQL Developer 18.1.0.x for several years now, but I’d really like to upgrade and stay current with the new releases. I’ve been holding out because I can’t seem to get the current code formatter to match the format I’ve grown accustomed to in v18.x. I use this feature constantly, so it’s been a major roadblock to adopting the current release.
I’ve tried matching my settings 1-to-1 between versions, and I’ve even experimented with the Arbori custom format - all to no avail. The main setting I can’t seem to adjust is line breaks within functions (around parentheses). Even a simple TO_CHAR() in a SELECT goes from this (v18.1.0.095.1630):
TO_CHAR(TRANS_DATE, 'MM/DD/YYYY') AS "TRANS_DATE",
to this (v21.4.1.349.1822):
TO_CHAR(
TRANS_DATE, 'MM/DD/YYYY'
)AS "TRANS_DATE",
This makes the code much harder to read when there are nested functions in a query. For example (disclaimer: not my code), this snippet goes from 1 line in v18.1.0.x:
DECODE(NORMAL_BAL, 'C', DECODE(DR_CR_IND, '+', TRANS_AMT, 0), 'D', DECODE(DR_CR_IND, '-', TRANS_AMT, 0) ) AS "CREDITS",
to 7 lines in v21.4.1.x:
DECODE(
NORMAL_BAL, 'C', DECODE(
DR_CR_IND, '+', TRANS_AMT, 0
), 'D', DECODE(
DR_CR_IND, '-', TRANS_AMT, 0
)
)AS "CREDITS",
I've attached exports of my Advanced Format settings from both v18x and v21x for comparison. Any insight or suggestions?
Much appreciated!
Code_Style_Advanced_Format_v21x_rev01.xml.txt (1.93 KB)Code_Style_Advanced_Format_v18x.xml.txt (1.65 KB)