Wishlist: Beautifier

[ScottMattes]

- returning ... into ... is not put on separate lines

I would like options to

- force a space before/after ":=", "(", ")", "+", "-", "", "", ":=", etc.

- I prefer

exception
when others
then
code goes here;
end;

and

procedure my_proc
is
begin
null;
end;

and

function my_func
return integer
is
begin
return( 1 );
end;

Thank you for your consideration. The Beta is looking real good.

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[ScottMattes]

I just thought of a couple more:

- an option to force x number of blank lines before the proc/func lines

- comments after a Begin/Then/etc should stay with that keyword rather than going to a new line

 

[William Robertson]

While we're at it, if it could generate

SELECT firstcol
     , secondcol
     , thirdcol
FROM   tab1
     , tab2
     , etc
WHERE  ...

it would save me a lot of manual re-editing. For some utterly bizarre reason it chooses to give me

SELECT firstcol
      ,secondcol
      ,thirdcol
FROM   tab1
      ,tab2
      ,etc
WHERE  ...

which surely no civilized person in their right mind would consider acceptible etc etc.