PLSQL快捷键设置技巧

sdf=SELECT DISTINCT * FROM
scf=SELECT COUNT(*) FROM
sf = SELECT * FROM
w = WHERE
ii = INSERT INTO
df = DELETE FROM
tt = TRUNCATE TABLE
k2 = ('','')
k3 = ('','','')
k4 = ('','','','')
k5 = ('','','','','')
k6 = ('','','','','','')
k7 = ('','','','','','','')
k8 = ('','','','','','','','')
V=VALUES
nt = NOT EXISTS SELECT 1 FROM (SELECT FROM b WHERE b. = a. )
bt = BETWEEN AND
kp2 = ('''','''')
kp3 = ('''','''','''')
kp4 = ('''','''','''','''')
kp5 = ('''','''','''','''','''')
kp6 = ('''','''','''','''','''','''')
kp7 = ('''','''','''','''','''','''','''')
kp8 = ('''','''','''','''','''','''','''','''')
checktable=select f.tablespace_name, a.total, (a.total - f.free) used, f.free,round((f.free / a.total) * 100) "Free% " from (select tablespace_name, sum(bytes / (1024 * 1024)) total from dba_data_files group by tablespace_name) a, (select tablespace_name, round(sum(bytes / (1024 * 1024))) free from dba_free_space group by tablespace_name) f where a.tablespace_name = f.tablespace_name(+) and a.tablespace_name in ('APP_REPDB','IND_REPDB','UNDOTBS1') order by "Free% ";
checktimelog=SELECT * FROM Time_Log WHERE (to_char(yestime,'yyyy-mm-dd hh24:mi:ss') between to_char(sysdate-1,'yyyy-mm-dd')||' 21:20:00' and to_char(sysdate,'yyyy-mm-dd')||' 21:20:00') AND remarks LIKE '%PRC_p_callout_activity_start%';
checkPRC=select TO_CHAR(sysdate, 'yyyy-mm-dd') AS STATISTICDATE, t0.objectid, t0.objectname, t0.dispatchno, t1.yestime starttime, t2.yestime endtime, round((t2.yestime - t1.yestime) * 24 * 60, 2) mm from s_etlobject t0, (select substr(remarks, 1, length(remarks) - 6) remarks, yestime from time_log where yestime between to_date(to_char(sysdate-1,'yyyy-mm-dd')||' 21:20:00', 'yyyy-mm-dd hh24:mi:ss') and to_date(to_char(sysdate,'yyyy-mm-dd')||' 12:20:00', 'yyyy-mm-dd hh24:mi:ss') and remarks like 'PRC%' and remarks like '%start') t1, (select substr(remarks, 1, length(remarks) - 4) remarks, yestime from time_log where yestime between to_date(to_char(sysdate-1,'yyyy-mm-dd')||' 21:20:00', 'yyyy-mm-dd hh24:mi:ss') and to_date(to_char(sysdate,'yyyy-mm-dd')||' 12:20:00', 'yyyy-mm-dd hh24:mi:ss') and remarks like 'PRC%' and remarks like '%end') t2 where t0.objectid = t1.remarks(+) and t0.objectid = t2.remarks(+) and t0.validflag = '1' order by t0.dispatchno;
checkalltable = select segment_name, sum(bytes)/(1024*1024) Mbytese from user_segments where segment_type='TABLE' group by segment_name order by sum(bytes)/(1024*1024) desc ;
checkalltables = select segment_name, sum(bytes)/(1024*1024) Mbytese from user_segments where segment_type='TABLE' and substr(segment_name,1,1) in ('L','S') group by segment_name order by segment_name asc ;
sflog = select * from s_log order by endtime desc,errorsql asc;