【PL/SQL】 快速替换sql关键字

自动替换设置

Tools–>Preferences–>Editor–>AutoReplace(自动替换)–>文件夹　　选取自定义文件（文件不能删除）

 

 

shortcuts.txt内容

i=INSERT
u=UPDATE
s=SELECT
f=FROM
w=WHERE
o=ORDER BY
g=GROUP BY
d=DELETE
df=DELETE FROM
dis=DISTINCT
sf=SELECT * FROM
sft=SELECT t.*,t.rowid FROM
sc=SELECT COUNT(*) FROM
sfu=SELECT * FROM FOR UPDATE
cor=CREATE OR REPLACE
p=PROCEDURE
fn=FUNCTION
ter=TIGGER
v=VIEW
sso=SET serveroutput ON

 

in=INSERT
up=UPDATE
se=SELECT
fr=FROM
wh=WHERE
ob=ORDER BY
gb=GROUP BY
de=DELETE
df=DELETE FROM
dis=DISTINCT
sf=SELECT * FROM
sft=SELECT t.*,t.rowid FROM
sc=SELECT COUNT(*) FROM
sfu=SELECT * FROM FOR UPDATE
cor=CREATE OR REPLACE
pr=PROCEDURE
fn=FUNCTION
ter=TIGGER
vi=VIEW
sso=SET serveroutput ON

 

 

使用方法

　　缩写加空格　　如 输入sft +空格