PL/SQL Beautifier - Subquery factoring clause(WITH AS)

[Windkracht8]

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

Can this be added to the feature request list?

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[kamrath]

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.

 

[Marco Kalter]

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

 

[cpetty1963]

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).

 

[mamv]

How about analytic functions with partition by clause?

I would love the possibility of choosing between this

SELECT ROW_NUMBER() OVER (PARTITION BY field1, field2, field3
                              ORDER BY field1, field2)
  FROM DUAL;

and this

SELECT ROW_NUMBER() OVER (PARTITION BY field1,
                                       field2,
                                       field3
                              ORDER BY field1,
                                       field2)
  FROM DUAL;

Cheers

 

[idumitru]

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

htp.p('
var x = "";
');

to not be splitted into many lines like this:

htp.p('
var x = "";
');

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

Thanks!

 

[Marco Kalter]

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