PLSQL Developer

PLSQL Developer 13 注册码
product code： 4vkjwhfeh3ufnqnmpr9brvcuyujrx3n3le
serial Number：226959
password: xs374ca

快捷键

  • File/New/SQL Window = Ctrl+T
  • Tools/Code Assistant = Alt+/
  • Session/Execute = F8
  • Edit/Recall Statement = Ctrl+E
  • Tools/Source/PL/SQL Beautifier = Shift+Ctrl+F

设置

Editor -> AutoReplace

1
2
3
4
5
sf = select * from
scf = select count(1) from
df = delete from
fu = for update
gp = group by

User Interface -> PL/SQL Beautifier

Items on one line
Syntax Case to Lowercase

Oracle -> Logon History

Oracle -> Connection

避免误操作Session Mode改为Dual或Single，Multiple Connections取消勾选Allow multiple connections

Tools -> Recall Statement

set Maximum size to 1000

Encoding

自动识别确保导出查询结果至剪切板时不会乱码

技巧

变量绑定

使用&id占位符

Special Copy

Right Click -> Special Copy -> Java

AfterConnect.sql & Login.sql

1
alter session set NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF';

Reference