PLSQL快捷输入
在PLSQL中通过tool>>preferences>>user interface>> editor>>autoreplacea
ss=select t.*, rowid from
sf=select * from
sc=select count(*) from
w=where
ob=order by
gb=group by
ii=insert into
di=distinct
df=delete from
tc=to_char(,'yyyymmdd')
td=to_date('','yyyymmdd')
hc=having count(1) >1;
alt=select * from all_tables t WHERE 1=1 AND t.TABLE_NAME='';
als=select * from all_source t where t.text like '%%';