About PL/SQL Beautifier Rules,a bug?

yangjie

Member
when i use the pl/sql beautifier to beatify the insert block,there is a problem.no matter "DML.SelectItemList.Format" value is,the insert block always show the only format,as follows:

Code:
Insert Into Test
   (columnA,
   (columnB,
   (columnC)
 Values
   (ValuesA,
    ValuesB,
    ValuesC)

Is it a bug of PL/SQL Beautifie? how can i do?

Version=1
RightMargin=76
Indent=2
UseTabCharacter=FALSE
TabCharacterSize=2
AlignDeclarationGroups=TRUE
AlignAssignmentGroups=TRUE
KeywordCase=3
IdentifierCase=3
UseSpecialCase=TRUE
ItemList.Format=1
ItemList.Align=TRUE
ItemList.CommaAfter=TRUE
ItemList.AtLeftMargin=FALSE
EmptyLines=1
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=1
DML.InsertItemList.Align=FALSE
DML.InsertItemList.CommaAfter=TRUE
DML.InsertItemList.AtLeftMargin=FALSE
DML.SelectItemList.Format=1
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
 
Last edited:
The insert statement doesn't seem quite right (too many parentheses). Is this a typo or is this the actual statement?
 
Marco Kalter said:
The insert statement doesn't seem quite right (too many parentheses). Is this a typo or is this the actual statement?

It is actual statement.If it is a "bug" about insert statement,is there any way to make the insert statement no effect? Some table more than 50 columns! :crazy:
 
Last edited:
Back
Top