plsql 常用快捷键

CreateTime--2018年4月23日17:33:05

Author:Marydon

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

ii=INSERT INTO

ins=INSERT

upd=UPDATE

sel=SELECT

fro=FROM

whe=WHERE

ob=ORDER BY

del=DELETE

df=DELETE FROM

sf=SELECT * FROM

scf=SELECT COUNT(1) FROM

sffu=SELECT * FROM FOR UPDATE

cor=CREATE OR REPLACE

pro=PROCEDURE

funn=FUNCTION

tri=TRIGGER

vie=VIEW

sso=SET SERVEROUTPUT ON

cur=CURSOR

ct=CREATE TABLE()

seq=SEQUENCE

cssw=CREATE SEQUENCE SEQ_ START WITH

corp=CREATE OR REPLACE PROCEDURE PROC_ () BEGIN END PROC_;

pknn=PRIMARY KEY NOT NULL

fk=FOREIGN KEY

cot=COMMENT ON TABLE IS '';

coc=COMMENT ON COLUMN IS '';

pk=PRIMARY KEY

con=CONSTRAINT

dis=DISTINCT

col=COLUMN

tab=TABLE

com=COMMENT

coti=COMMENT ON TABLE IS

coci=COMMENT ON COLUMN IS

com=COMMIT

row=ROWNUM

ba=BETWEEN AND

dec=DECODE

cwt=CASE WHEN THEN

gb=GROUP BY

wk=IS NULL

bwk=IS NOT NULL

ljo=LEFT JOIN ON

sum=SUM()

cou=COUNT(1)

uni=UNION

ua=UNION ALL

nn=NOT NULL

ref=REFERENCES

tru=TRUNCATE

ena=ENABLE

tra=TRANSLATE()

gre=GREATEST()

lea=LEAST()

cta=CREATE TABLE AS

sys=SYSDATE

dua=DUAL

tim=TIMESTAMP

fu=FOR UPDATE

srf=SELECT t.*,ROWID FROM

lik=LIKE '%'

upp=UPPER()

low=LOWER()

td=TO_DATE()

tc=TO_CHAR()

wlj=(+)

fd=FROM DUAL

hav=HAVING

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

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

编辑器-->自动替换