Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL formatting differences in 21.4 as compared to 21.2

stomDec 15 2021

Hi,
I upgraded to version 21.4 and kept all my preferences same as 21.2 version.
I see differences in sql formatting between the 2 versions. 21.2 is fine.
for example,
select nvl(sysdate, sysdate) from dual;
On 21.2, if I format the code, I get this:

image.pngOn 21.4:

image.pngHow do I revert this behaviour to same as 21.2?

Formatting a sql of 100+lines on the new version also takes very long. ~15 seconds. Is there an issue with the formatting in 21.4?

Comments
Post Details
Added on Dec 15 2021
4 comments
354 views