The PL/SQL Beautifier does not understand the subquery factoring clause.

Can this be added to the feature request list?

I have added this to the list of enhancement requests.

Please, please, please! The Beautifier hasn't been upgraded for quite some time. For me, this is the biggest pain-point using PL/SQL Developer. Having code well-formatted enormously enhances the ability to review the structure and understand what's going on. Pain points are...
* WITH clause;
* CASE statements... generally do them better, especially nested CASE statements;
* nested AND/OR's in the WHERE clause.

These things (and more) will all be addressed in 8.0.

Rather fundamental functionality to be pushed to a major release. Either you can beautify the code or you can't. This is not new Oracle functionality (meaning the WITH clause).

How about analytic functions with partition by clause?

I would love the possibility of choosing between this
and this

Cheers

Is there any way to avoid a long line containing multiple concatenations like this:

htp.p('
var x = "<OBJECT attribute1='''||val1||''' attribute1='''||val1||''' attribute1='''||val1||''' attribute1='''||val1||''' />";
');

to not be splitted into many lines like this:

htp.p('
var x = "<OBJECT attribute1='''||val1||
''' attribute1='''||val1||
''' attribute1='''||val1||
''' attribute1='''||val1||''' />";
');

after formating the code using beautifier? Which option should I supress to preserve one single line?

Thanks!

Only the right margin affects this. There is no explicit control over such a concatenation expression.