More beautifier options

[F. van Boven]

Hi,

I'm trying (for the first time) to use the beautiful to quickformat some PL/SQL code to our company standards. There are some options missing to make it work.

Can the following options be added:

- Casing of aliases
- List items on a new line

So the next code:

select o.ORDERID, o.ORDERDATE
from   VAN_ORDER o
where  o.ORDERID = 12345

becomes:

select
  o.ORDERID,
  o.ORDERDATE
from
  VAN_ORDER o
where
  o.ORDERID = 12345

Some weird formatting I've encountered:

- "group by" was formatted into "group by" (double spacing)?
- GREATEST and NVL are not formatting using the specified keywords syntax case

Should they already be there I can't find them

Thanx in advance,

Frank van Boven

 

[Marco Kalter]

I have added this to the list of enhancement requests.

I cannot reproduce the "group by" and "greatest" issues though. Do you have a complete example?

 

[F. van Boven]

Ah, I see what causes the "group by"...

The "by" is aligned with the identifiers, like this:

select FIELDNAME
from   TABLE
group  by FIELDNAME

 

[patch]

While you at it, please add an option to add a space before an identifier. Especially in the SQL statement when the comma is placed on the new line.
Regards,
Patrick