PLSQL自动补全
PLSQL Developer 的安装目录 PlugIns
“D:\New Folder\PlugIns”
“configure” – “Preferences” – “Editor” – “Autoreplace” --“Edit”,如图:
添加如下(内容根据自身使用习惯修改):
BE = BETWEEN AND
SC = SELECT COUNT(*) CNT FROM
CT = CREATE TABLE
D = DELETE
DT = DROP TABLE PURGE
DV = DROP VIEW
E = EXISTS
F = FROM
G = GROUP BY
H = HAVING
I = INSERT
L = LIKE '%%'
N = NULL
O = ORDER BY
S = SELECT * FROM
SY = SYSDATE
TC = TO_CHAR(,'YYYY-MM-DD')
TD = TO_DATE('','YYYY-MM-DD')
TN = TO_NUMBER()
U = UPDATE
W = WHERE
SD = SELECT DISTINCT FROM
保存为”AutoReplace.txt“,放在安装目录 PlugIns.
然后重启plsql