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

相关推荐：

　　 SettingsPLSQLDeveloper