【Oracle】PL/SQL配置

PL/SQL美化风格配置

【configure】→【Preference】→【User Interface】→【PL/SQL Beautifier】→【rules file】

配置文件：my_style.br

Version=1
RightMargin=80
Indent=4
UseTabCharacter=FALSE
TabCharacterSize=3
AlignDeclarationGroups=TRUE
AlignAssignmentGroups=TRUE
KeywordCase=1
IdentifierCase=1
UseSpecialCase=TRUE
ItemList.Format=1
ItemList.Align=TRUE
ItemList.CommaAfter=TRUE
ItemList.AtLeftMargin=FALSE
EmptyLines=1
ThenOnNewLine=FALSE
LoopOnNewLine=TRUE
DML.LeftAlignKeywords=TRUE
DML.LeftAlignItems=TRUE
DML.OnOneLineIfPossible=TRUE
DML.WhereSplitAndOr=TRUE
DML.WhereAndOrAfterExpression=TRUE
DML.WhereAndOrUnderWhere=FALSE
DML.InsertItemList.Format=0
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=1
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
[SpecialCase]

关键字大写

【configure】→【Preference】→【User Interface】→【Editor】→【Keyword case】

Objects文件夹个性化配置

【configure】→【Object Browser Folders】

操作快捷键设置

【configure】→【Preference】→【User Interface】→【Key Configuration】

自定义快捷输入

【configure】→【Preference】→【User Interface】→【Editor】

停止更新检查

【configure】→【Preference】→【Others】→【Update & News】