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 ON19 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 NULL25 fk=FOREIGN KEY
26 cot=COMMENT ON TABLE IS '';27 coc=COMMENT ON COLUMN IS '';28 pk=PRIMARY KEY29 con=CONSTRAINT30 dis=DISTINCT31 col=COLUMN32 tab=TABLE
33 com=COMMENT
34 coti=COMMENT ON TABLE IS35 coci=COMMENT ON COLUMN IS36 com=COMMIT37 row=ROWNUM
38 ba=BETWEEN AND39 dec=DECODE
40 cwt=CASE WHEN THEN41 gb=GROUP BY42 wk=IS NULL
43 bwk=IS NOT NULL44 ljo=LEFT JOIN ON45 sum=SUM()46 cou=COUNT(1)47 uni=UNION48 ua=UNION ALL49 nn=NOT NULL
50 ref=REFERENCES51 tru=TRUNCATE52 ena=ENABLE
53 tra=TRANSLATE()54 gre=GREATEST()55 lea=LEAST()
56 cta=CREATE TABLE AS57 sys=SYSDATE58 dua=DUAL
59 tim=TIMESTAMP60 fu=FOR UPDATE
61 srf=SELECT t.*,ROWID FROM62 lik=LIKE '%'63 upp=UPPER() low=LOWER()65 td=TO_DATE()66 tc=TO_CHAR()67 wlj=(+)68 fd=FROM DUAL69 hav=HAVING 将内容保存成shortcuts.txt⽂件,然后进⾏如下配置: 将shortcuts.txt保存到plsql的安装⽬录下; 编辑器-->⾃动替换写在最后 哪位⼤佬如若发现⽂章存在纰漏之处或需要补充更多内容,欢迎留⾔!!! 相关推荐: