PLSQL Developer设置

来源：互联网发布：跳跃网络充值积分编辑：程序博客网时间：2024/05/17 02:28

设置AutoReplace

sf=select t.*,t.rowid fromS*f = SELECT * FROMs=SELECTc=COUNTf=FROMw=WHEREo=ORDER BYsc=SELECT COUNT(1) FROMdis = DISTINCTg = GROUP BYdbo = DBA_OBJECTSsdbo=SELECT T.* FROM DBA_OBJECTS T WHERE T.OBJECT_NAME='';stb=SELECT * FROM USER_TABLES T;d=DISTINCT

SQL格式化

修改pl Beartifier.br文件

Version=1RightMargin=76Indent=2UseTabCharacter=FALSETabCharacterSize=2AlignDeclarationGroups=TRUEAlignAssignmentGroups=TRUEKeywordCase=1IdentifierCase=1UseSpecialCase=FALSEItemList.Format=1ItemList.Align=TRUEItemList.CommaAfter=TRUEItemList.AtLeftMargin=FALSEEmptyLines=1ThenOnNewLine=FALSELoopOnNewLine=FALSEDML.LeftAlignKeywords=FALSEDML.LeftAlignItems=FALSEDML.OnOneLineIfPossible=TRUEDML.WhereSplitAndOr=TRUEDML.WhereAndOrAfterExpression=FALSEDML.WhereAndOrUnderWhere=TRUEDML.JoinSplitBeforeOn=TRUEDML.InsertItemList.Format=1DML.InsertItemList.Align=FALSEDML.InsertItemList.CommaAfter=TRUEDML.InsertItemList.AtLeftMargin=FALSEDML.SelectItemList.Format=1DML.SelectItemList.Align=TRUEDML.SelectItemList.CommaAfter=TRUEDML.SelectItemList.AtLeftMargin=FALSEDML.UpdateItemList.Format=1DML.UpdateItemList.Align=TRUEDML.UpdateItemList.CommaAfter=TRUEDML.UpdateItemList.AtLeftMargin=FALSEParameterDeclarationList.Format=1ParameterDeclarationList.Align=TRUEParameterDeclarationList.CommaAfter=TRUEParameterDeclarationList.AtLeftMargin=FALSERecordFieldList.Format=1RecordFieldList.Align=TRUERecordFieldList.CommaAfter=TRUERecordFieldList.AtLeftMargin=FALSESplitAndOr=FALSEAndOrAfterExpression=FALSE[SpecialCase]

0 0