plsqldev 技巧

1、快捷补全代码

sf = select a.* from 
st = select a.* ,a.rowid from a
sc* = select count(*) from a
sw = select a.* from a where a
w = where
l = like '%%'
o = order by
insw = in (select a from a where a )
f = for update
u = update t set t. where t

2、复制excel数据到plsql

先点新行最左边，再点对应字段框的最上面，在粘贴数据即可。

3、设置sql自动换行

设置 - 用户界面 - 编辑器 - 跳格与换行 - 自动换行