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!

4.2EA2 SQL Formatter IF THEN ELSE suggestion

3417476Mar 22 2017 — edited Mar 28 2017

Although the "line breaks" section in the SQL Formatter "advanced" tab has a section dedicated to CASE it does not have one for IF / THEN / ELSE and indeed it seems that the

setting for THEN in a CASE expression affects IF / THEN / ELSE as well.

Deciding whether THEN should appear on the same line as IF is, in my experience, perhaps the single most emotive topic in code formatting in all languages and I would suggest an easy way for people to choose.

--Tony

Comments

Sharmela-Oracle

Hi,

Set UseCanonicalName to off and check if it helps.

-Sharmela

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 25 2017
Added on Mar 22 2017
9 comments
551 views