ii=INSERT INTO
u=UPDATE
s=SELECT
f=FROM
w=WHERE
ob=ORDER BY
d=DELETE
df=DELETE FROM
ssf=SELECT * FROM
sc=SELECT COUNT(*) FROM
co=count(1)
sfu=SELECT * FROM FOR UPDATE
cor=CREATE OR REPLACE
p=PROCEDURE
fn=FUNCTION
v=VIEW
fy=select * from (select rownum rn,t.* from ( select e.* from emp e order by e.sal desc--替换部分) t where rownum<11) where rn>0 ;
sd=sysdate
lj=left join
rj=right join
ij=inner join
li=like '%%'
td=to_date('2012-05-31','yyyy-mm-dd hh24:mi:ss')
dual=select * from dual;
gb=group by
li=Like '%%'
be=Between AND
top=select * from (select * from 表 where 列 in (0,2) ) t where rownum <=10
in=in (
