PLSQL 快捷键

1).建立一个文本文件PlugIns.txt，并写入如下内容：
s = SELECT * FROM
w = WHERE
b = BETWEEN  AND
l = LIKE '%%'
o = ORDER BY
insw = IN (SELECT a FROM  a WHERE a )
sw = SELECT * FROM  t WHERE t
sc = SELECT COUNT(*) FROM  t
st = SELECT t.* ,t.ROWID FROM  t
f = FOR UPDATE
u = UPDATE  t SET t. WHERE t

另存到PL/SQL Developer的安装路径下的~\PlugIns目录下  
2).Tools-->Preferences-->User Interface-->Editor-->AutoReplace，选中Enable复选框，然后浏览文件选中之前创建的PlugIns.txt，点击Apply  
3).重启PL/SQL Developer，在sql窗口中输入s+空格，w+空格，sc+空格做测试