Beautifier and CASE Statement

[ifernan]

Hi.

This kind of construction is not beautified (PL/SQL Developer v7.1.1.1339).

ld_dateoff := CASE (lct_dateofftype)
               WHEN 'D' THEN SYSDATE + TO_NUMBER(li_ndays)
               WHEN 'F' THEN to_date(lv_dateoffdate, 'DD/MM/YYYY')
               ELSE NULL END;

Beautifer returns a single line with all this code. Is there any way to get this statement rightly beautified?

Regards,
ifernan

 

[Marco Kalter]

There is no control for this yet, but it's on the to-do list.

 

[ifernan]

Thanks anyway!

Apart from the Options in the PL/SQL Beautifier Rules Editor, is there anyway to customize the Beautifier process? I am talking about something like an external file with customized rules for things not supported by default.

Regards,
ifernan

 

[Stew Stryker]

I'd like to see the Beautifier support the CASE statement better too.

 

[ifernan]

In the meantime what about a start tag and end tag to avoid to be beautified.

For example:

code to be beautified;

 -- START: DONT BEAUTIFIE
     my CASE statement
             beautified
        like I
             want;
 -- END: DONT BEAUTIFIE

    code to be beautified;

Regards