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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Code formatting issues in SQL Developer with line breaks on comma option

User_NV07XDec 18 2019 — edited Dec 20 2019

I am using SQL Developer Version 19.2.1.247 with default settings.

I change line breaks on comma from "After" to "Before". This leads to awkward indentation in function calls and select lists, because everything past the first row is offset by one. If I remember correctly, previous version of SQL Developer had already solved this issue and properly aligned column names and function arguments vertically. How do I restore this behaviour?

vertical_alignment.JPG

I also have issues with the formatting of analytic functions. Starting with default settings, I check the box for line breaks on procedure arguments. The results looks fine, all arguments to the partition by clause are vertically aligned. When I change line breaks on comma from "After" to "Before", however, the alignment no longer works. Is there a way to preserve vertical alignment with line breaks before comma and line breakson procedure arguments enabled?

This looks fine:

analytic_function_line_breaks_after.JPG

This does not:

analytic_function_line_breaks_before.JPG

This post has been answered by Vadim Tropashko-Oracle on Dec 19 2019
Jump to Answer

Comments

Post Details

Added on Dec 18 2019
5 comments
2,574 views