Beautifier Problem with UNPIVOT

[Ralph67]

Hi,

it seems the PL/SQL Beautifier is not able to format sql statements with UNPIVOT properly. There is no linebreak in the UNPIVOT ... FOR ... IN part so the "IN" list is moved extremly to the right side (even beyond the right margin specified in the beautifier settings). Is there a way to fix that?

Ralph

 

[Marco Kalter]

We'll enhance this.

 

[Ralph67]

Hi Marco,

we have switched to PL/SQL Developer 11 (11.0.41774) but the problem is still there

Any idea when this will be fixed?

Best regards

Ralph

 

[Jeff Kandt]

I'm working with a large select statement with an UNPIVOT right now and I'm banging into this, too. The beautifier ends up indenting an important section of the statement way out to the right where I can't see it without scrolling.

ProTip: I had recently checked a bunch of the "Automatically Beautify" options, and was about to turn them off again due to this problem, but then I found the "NoFormat Start" and "NoFormat End" directives in the documentation (25.4) which will let me tell the Beautifier to keep its grubby mitts off of this particular statement but still allow me to auto-beautify everything else.

 

[Ralph67]

Any news on this topic? We think about switching to PL/SQL Developer 12. Is this problem fixed in Version 12?

 

[rbrooker]

you can always use a comment '--' to force a line break ...