Flexible beautifier

[Sparrow]

I need more flexible beautifier. For example, I want to have opportunity put a end-bracket on next line after end line with code text and fisrt line with code in sub-query must be in new line after start-bracket, like this:

select t.*
    from MyTable t
   where t.sCode in (
           select st.sMasterCode
             from SecondTable st
         )

I need to have opportunity split comma with next word in block select query, like this:

select t.id
       , t.sCode
       , t.sText
    from MyTable t

I want to have hint and first field in block-select query be aligned, like this:

select t.*
    from MyText t
   where t.sCode in (
           select --+Cardinality(ids 1)
                  column_value
             from table(idArray) ids
         )

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[koja]

I agree with The Mighty Sparrow; the beautifier is nice, but could use some enhancements. Above suggestions make sense to me.
I look forward to more block-layout improvements:

procedure beautify
( p_src in out nocopy varchar2             -- ...
, p_stl in            char     default 'B' -- [B(lock)|C(ompact)|W(ide)]
, ...
) is
begin
  -- beautify the code
end beautify;