PL/SQL设置

PL/SQL 自定义快捷键（比如输入s，直接就显示select * from）

1.1 修改Code assistant快捷键
tools->preferences->User Interface -> Key Configuration -> tools/ code assistant 改为自己想要的快捷键
tools -> code assistant 可以查看帮助的快捷键

--1.2PL/SQL实现关键字自动转换成大写
TOOLS----->perferences---->editor---->keyword case>>uppercase

2
--2.1修改 Sql 语句大小写
默认 pl/sql 没有提供 快捷键
选中sql,点击 edit --> selection --> Uppercase
当然了也可以按照1.1来增加快捷键
tools->preferences->User Interface -> Key Configuration --> edit/selection/Uppercase 改为自己想要的快捷键

--2.2在PL/SQL的安装目录下面：$:Program FilesPLSQL DeveloperPlugIns 中添加一个文本文件，比如命名为:shortcuts.txt
打开PL/SQL，在Tools->Perferences->Editor中Autoreplaces选择配置的shortcuts文件。

--shortcuts.txt
SF =SELECT * FROM
SFW =SELECT * FROM T WHERE
SRF = SELECT T.* ,T.ROWID FROM T
WH = WHERE
OB = ORDER BY
SDF = SELECT DISTINCT FROM T
SDFO = SELECT DISTINCT FROM T ORDER BY
SFO = SELECT * FROM T ORDER BY
COU = COUNT(*)
SSFG = SELECT ,SUM(1) FROM T GROUP BY
SCFG = SELECT ,SUM(1) FROM T GROUP BY
SCF = SELECT COUNT(1) FROM T
SSF = SELECT SUM() FROM T
SCFW = SELECT COUNT(1) FROM T WHERE
SSFW = SELECT SUM() FROM T WHERE