sf=SELECT * FROM
saf=SELECT a.* FROM
sbf=SELECT b.* FROM
scf=SELECT c.* FROM
sdf=SELECT d.* FROM
sc=SELECT COUNT(1) FROM
sct=SELECT COUNT(1) FROM user_tables
se=SELECT
up=UPDATE
wg=WITHIN GROUP
ins=INSERT INTO
de=DELETE
wh=WHERE
ord=ORDER BY
li=LIKE '%%'
fr=FROM
df=DELETE FROM
gr=GROUP BY
gra=GRANT
ha=HAVING
di=DISTINCT
cr=CREATE
pr=PROCEDURE
fu=FUNCTION
ti=TIGGER
vi=VIEW
un=UNION
ua=UNION ALL
seq=SEQUENCE
mo=MODIFY
ta=TABLE
fo=FOR UPDATE
va=VALUES()
nv=NVL()
al=ALTER
re=RENAME
col=COLUMN
cor=CREATE OR REPLACE
com=COMMENT ON COLUMN
cu=CREATE USER
ide=IDENTIFIED BY
dr=DROP
co=COMMIT;
ro=ROLLBACK;
du=dual;
wm=wm_concat()
re=replace()
su=substr()
toc=to_char()
tod=to_date()
inc=increment by
st=start with
var=VARCHAR2(4000)
nu=NUMBER
tr=TRUNCATE
jo=JOIN
lj=LEFT JOIN
rj=RIGHT JOIN
fj=FULL JOIN
ij=INNER JOIN
sw=START WITH
cbp=CONNECT BY PRIOR
tt=TRUNCATE TABLE
dt=DROP TABLE
ov=OVER
row=row_number()
pa=partition by
alt=ALTER TABLE
cs=CREATE SEQUENCE
cur=CURSOR
css=CREATE SEQUENCE SEQ_P_PRO_INVEST_BONUS_ID start with 1000 nomaxvalue nocache nocycle;
转载于:https://www.cnblogs.com/xsdf/p/7992344.html