Experimenter for Tidycode Pl/Sql Formatter

Command line:

Original source

Formatted source

Tidycode Pl/Sql Formatter 2.4.2
Input file to be tidied is source643174609242.sql.
Output file is source643174609242.sql.tdy.
Character set is US7ASCII.
Indentation is on.(-in+)
A tab size is equal to 4 spaces.(-t)
Only spaces will be used for indenting.
An indent is equal to 2 spaces.(-is)
The spaces are removed after opening brackets.(-rsaob+)
Spaces are removed before closing brackets.(-rsbcb+)
Generally,the redundant spaces (more than 1 space) will be reduced to 1 space.(-c+)
The space around operations(+,-..) will be removed.(-co+)
There will be one space around operations(+,-..).(-sao+)
Declarations will be indented.(-id+)
There will be an extra indentation after 'exception' WHEN.(-iaew+)
There will be an extra indentation after 'case' WHEN.(-iacw+)
There will be indentation after CURSOR.(-iac+)
The code inside begin/end block will be indented.(-iibe+)
LOOP/THEN will be indented with the next block.(-iltwb+)
Each line will be indented in a nicer way.(-ni+)
The sql keywords will be converted into their uppercase form.(-uk+)
The identifiers will be in lowercase.(-li+)
Elements of comma separated lists inside brackets will be arranged in column form.(-clb+)
Commas on the left will moved to the rigth hand side.(-pcr+)
Types in declarations will be aligned vertically.(-acdv+)
Consecutive assignments will be aligned vertically.(-acav+)
Consecutive arrows will be aligned vertically.(-acarv+)
Conditions in IFs will be aligned left.(-ac+)
Left hand side of assignment will be aligned left.(-aroa+)
The way variables are written in declarations, so they will look elsewhere.(-dbvn+)
Non-keywords of selects will be left-adjusted.(-as+)
Non-keywords of updates will be left-adjusted.(-au+)
The conditions of 'where'  will be aligned/left-adjusted.(-aaw+)
Each 'then' will be placed in the last line of if condition.(-kitt+)
Each 'loop' are placed in the last line of while condition.(-kwlt+)
Each 'loop' are placed in the last line of for condition.(-kflt+)
Extra whitespace is removed before is/as.(-kpit+)
Each 'then' will be placed in the last line of when condition.(-kwtt+)
'Into' keywords will be placed under select.(-pius+)
And/or/not keywords will be placed under where/having.(-plouwh+)
The sqls will be right-aligned.(-rask+)
Sql statements will be broken up.(-buq+)
Lines with multiple statements will be converted into single statement lines.(-buml+)
A linebreak will be inserted after each if if there is no any.(-mlai+)
Linesbreaks will be removed after each if.(-rlai+)
A linebreak will be inserted after each for loop if there is no any.(-mlaf+)
Linesbreaks will be removed after each for loop.(-rlaf+)
A linebreak will be inserted after each while loop if there is no any.(-mlaw+)
Linebreaks will be removed after each while loop.(-rlaw+)
A linebreak will be inserted after each loop loop if there is no any.(-mlal+)
Linebreaks will be removed after each loop loop.(-rlal+)
A linebreak will be inserted after each procedure if there is no any.(-mlapr+)
Linebreaks will be removed after each procedure.(-rlapr+)
A linebreak will be inserted after each package if there is no any.(-mlapa+)
Linebreaks will be removed after each package.(-rlapa+)
Backup directory is: .(-bdir)
Number of backup versions to keep: 0.(-b)