Oracle : PL SQL Developer Beutifier (allaroundautomations)

While writing a SQL code or reviewing the code written by team memberes(which is tadious job) it is better that you should have a tool or method which will format the code for you.

The PL/SQL Beautifier allows you to format your SQL and PL/SQL code through a user-defined set of rules. Your code can automatically be beautified when you compile, save, or open a file.

Example –

Steps to use Use PL SQL Developer  beutifier rules –

 --Create a rule file.Add extension as br.

Test.br

Version=1

RightMargin=90

Indent=3

UseTabCharacter=FALSE

TabCharacterSize=3

AlignDeclarationGroups=TRUE

AlignAssignmentGroups=TRUE

KeywordCase=1

IdentifierCase=0

UseSpecialCase=TRUE

ItemList.Format=2

ItemList.Align=TRUE

ItemList.CommaAfter=TRUE

ItemList.AtLeftMargin=FALSE

EmptyLines=2

ThenOnNewLine=FALSE

LoopOnNewLine=FALSE

DML.LeftAlignKeywords=FALSE

DML.LeftAlignItems=FALSE

DML.OnOneLineIfPossible=TRUE

DML.WhereSplitAndOr=TRUE

DML.WhereAndOrAfterExpression=FALSE

DML.WhereAndOrUnderWhere=TRUE

DML.InsertItemList.Format=2

DML.InsertItemList.Align=FALSE

DML.InsertItemList.CommaAfter=TRUE

DML.InsertItemList.AtLeftMargin=FALSE

DML.SelectItemList.Format=2

DML.SelectItemList.Align=TRUE

DML.SelectItemList.CommaAfter=TRUE

DML.SelectItemList.AtLeftMargin=FALSE

DML.UpdateItemList.Format=2

DML.UpdateItemList.Align=TRUE

DML.UpdateItemList.CommaAfter=TRUE

DML.UpdateItemList.AtLeftMargin=FALSE

ParameterDeclarationList.Format=2

ParameterDeclarationList.Align=TRUE

ParameterDeclarationList.CommaAfter=TRUE

ParameterDeclarationList.AtLeftMargin=FALSE

RecordFieldList.Format=1

RecordFieldList.Align=TRUE

RecordFieldList.CommaAfter=TRUE

RecordFieldList.AtLeftMargin=FALSE

SplitAndOr=FALSE

AndOrAfterExpression=FALSE

2
                  --Go to –PL SQL Developer àPreferences à PL SQL Beutifier

      --Browse the Test.br file created already and check the option that you want when beutifier should be called.There are following four options.

·         After Creating

·         After Loading

·         Before Compling

·         Before Saving

 click apply and you are done.