Enhancement request(s) for the beautifier

[keckhard]

hi,
we realy love the beautifier and use it in our projects. but we are missing support for a few pl/sql / sql things:

- FETCH some_cursor BULK COLLECT INTO : for this statement after beautifying the code all variables are apearing at one line.
- concat (||) if we need realy long varchar2 texts (concatenation of different variables or for readability concatenation of some hardcoded texts), after beautifying the code the concatenation of the variables/texts appears at one line. if you write longer mathematical expressions, you have the same problem. you can not write such statements readable when you use the beautifier. there should be a way to not beautify particular code fragments. (e.g. by specifying a 'dont beautify' start and end tag)
- the CASE statement is beautyfied to one line (could you handle this similar to an IF statement?)
- im not sure, but i think there are similar problems with the RETURNING clause of insert/update/delete statements
- last problem: empty lines are not counted by oracle. so if an exception occurs and you have empty lines in your code, a wrong line number is showed by oracle. could you implement an automatic replacement of empty lines (by empty comments?)

thx and best regards, klaus.

 

[Gustavo]

after beautifying the code the concatenation of the variables/texts appears at one line

You can set right margin to something like 78. I don't know if this is the only thing to set, but I don't have everything in a single line like you do.

 

[keckhard]

hi,
we already tried this but, we often use record types and pl/sql. so we have very often lines with more than 78 characters. for example the beautifier breaks the following code line (if you have a right margin of 78) after the 2nd and 3rd point
v_artkmk_col(i).ARTKMK_ROOTARTK_ID := nvl(v_artkmk_col(i) .ARTKMK_ROOTARTK_ID
, v_artkmk_col(i)
.artkmk_artk_id);
what means, that the object and its member variable is seperated what dicreases readability.
to avoid this we use a right margin of 160 an print code in landscape.
br, klaus.

 

[keckhard]

hi,
is there anybody out there?
br, klaus.

 

[ScottMattes]

Yes, I'm out here. Just a user of the product. I peek to see what is being asked/said every work day. Marco, one of the AllRoundAutomations people is here every workday too, answering questions.

 

[Marco van der Linden]

Over the last two years quite a number of enhancement request with respect to the beautifier have been filed. Marco promised 'us' that a lot of these requests will be handled by release 8.0. Personally I think it would be great if the beautifier would work with a 'flexible' template where you can define your own preferences sort of 'free-style'. I would like to be able to left allign comma's with the SELECT keyword, align IN/OUT indicators in procedure definitions (as shown below) and some other peculiarities of my own programming style.

@Marco: we're nearing Q4. Can we expect 8.0 beta anytime soon (not trying to push/rush you, just eager )

SELECT column1
,      column2
--
procedure my_proc(p_1         IN     NUMBER
                 ,p_something IN OUT VARCHAR2
                 ,p_3            OUT NUMBER
                 )

 

[JEK]

Originally posted by Marco van der Linden:
Personally I think it would be great if the beautifier would work with a 'flexible' template where you can define your own preferences sort of 'free-style'.

Yeah... I definitely second that!

Originally posted by Marco van der Linden:
I would like to be able to left allign comma's with the SELECT keyword

And I would like to be able to right align comma's with the select keyword, just like SQLDetective does.

select x.column_a
     , x.column_b
  from table x