PLSQL Developer设置

最新推荐文章于 2025-07-14 10:01:03 发布

原创最新推荐文章于 2025-07-14 10:01:03 发布 · 759 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#plsql developer

Tools 专栏收录该内容

4 篇文章

订阅专栏

本文介绍了一种SQL格式化的设置方法，通过配置plBeartifier.br文件实现SQL语句的规范化排版，包括关键字大小写、缩进、换行等细节调整。

设置AutoReplace

sf=select t.*,t.rowid from
S*f = SELECT * FROM
s=SELECT
c=COUNT
f=FROM
w=WHERE
o=ORDER BY
sc=SELECT COUNT(1) FROM
dis = DISTINCT
g = GROUP BY
dbo = DBA_OBJECTS
sdbo=SELECT T.* FROM DBA_OBJECTS T WHERE T.OBJECT_NAME='';
stb=SELECT * FROM USER_TABLES T;
d=DISTINCT

SQL格式化

修改pl Beartifier.br文件

Version=1
RightMargin=76
Indent=2
UseTabCharacter=FALSE
TabCharacterSize=2
AlignDeclarationGroups=TRUE
AlignAssignmentGroups=TRUE
KeywordCase=1
IdentifierCase=1
UseSpecialCase=FALSE
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.JoinSplitBeforeOn=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=1
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]