Feature request - Beautifier - More options for leading commas and keywords

[Guttorm]

We prefer to have our separators (commas or keywords) neatly aligned on the left side. The beautifier *almost* supports our way of doing it, but not quite..

We would also like indents to be fixed, and not dependent on the length of, for instance, the prrocedure name.

We would like the following changes;
1) When comma is in front of item, and the item is on a separate line, align the comma with keywords and have a space after it.

Example:

select depno as department_number
         , dname as departmen_name
         , loc   as department_location
      from dept
         , emp
      ..

2) When parameters are on separate lines, put the first parameter on a separate line also, and use a fixed indent

Example:

procedure InsertDept
        ( p_deptno in out dept.deptno%type
        , p_dname  in dept.dname%type
        , p_loc    in dept.loc%type
        ) is

3) Break statements on sub-selects

Example:

select depno as department_number
         , dname as departmen_name
         , loc   as department_location
      from dept
         , emp
     where dept.deptno = emp.deptno
       and emp.empno
        in ( select ..
               from ..
              where ..
           )

This is my first attempt at formatting, so I hope it turns out ok..

Guttorm

 

[Marco Kalter]

I have added this to the list of enhancement requests.