plsql 配置常用快捷键（自动替换）

如果是配置常用快捷键的话，见文末推荐。

说明：这里的快捷键，不同于以往的快捷键，输入指定字符，按快捷键，可以自动替换成你所配置的指定内容

 1 ii=INSERT INTO
 2 ins=INSERT
 3 upd=UPDATE 
 4 sel=SELECT 
 5 fro=FROM 
 6 whe=WHERE 
 7 ob=ORDER BY 
 8 del=DELETE 
 9 df=DELETE FROM 
10 sf=SELECT * FROM 
11 scf=SELECT COUNT(1) FROM 
12 sffu=SELECT * FROM FOR UPDATE 
13 cor=CREATE OR REPLACE 
14 pro=PROCEDURE 
15 funn=FUNCTION 
16 tri=TRIGGER 
17 vie=VIEW 
18 sso=SET SERVEROUTPUT ON
19 cur=CURSOR
20 ct=CREATE TABLE()
21 seq=SEQUENCE
22 cssw=CREATE SEQUENCE SEQ_ START WITH 
23 corp=CREATE OR REPLACE PROCEDURE PROC_ () BEGIN END PROC_;
24 pknn=PRIMARY KEY NOT NULL
25 fk=FOREIGN KEY
26 cot=COMMENT ON TABLE IS '';
27 coc=COMMENT ON COLUMN IS '';
28 pk=PRIMARY KEY
29 con=CONSTRAINT
30 dis=DISTINCT
31 col=COLUMN
32 tab=TABLE 
33 com=COMMENT
34 coti=COMMENT ON TABLE  IS
35 coci=COMMENT ON COLUMN  IS
36 com=COMMIT
37 row=ROWNUM
38 ba=BETWEEN AND
39 dec=DECODE
40 cwt=CASE  WHEN THEN
41 gb=GROUP BY
42 wk=IS NULL
43 bwk=IS NOT NULL
44 ljo=LEFT JOIN ON
45 sum=SUM()
46 cou=COUNT(1)
47 uni=UNION
48 ua=UNION ALL
49 nn=NOT NULL
50 ref=REFERENCES
51 tru=TRUNCATE
52 ena=ENABLE
53 tra=TRANSLATE()
54 gre=GREATEST()
55 lea=LEAST()
56 cta=CREATE TABLE AS
57 sys=SYSDATE
58 dua=DUAL
59 tim=TIMESTAMP
60 fu=FOR UPDATE
61 srf=SELECT t.*,ROWID FROM
62 lik=LIKE '%'
63 upp=UPPER()
64 low=LOWER()
65 td=TO_DATE()
66 tc=TO_CHAR()
67 wlj=(+)
68 fd=FROM DUAL
69 hav=HAVING

　　将内容保存成shortcuts.txt文件，然后进行如下配置：

　　将shortcuts.txt保存到plsql的安装目录下；

　　编辑器-->自动替换

写在最后

　　哪位大佬如若发现文章存在纰漏之处或需要补充更多内容，欢迎留言！！！

 相关推荐：

posted @ 2018-04-23 18:07  Marydon  阅读(4191)  评论(0)  编辑  收藏  举报