?? insert_to_day.sql
字號:
DECLARE v_hour VARCHAR2(2); v_day VARCHAR2(2); v_sqlStr VARCHAR2(900); BEGIN v_hour := to_char(sysdate-1/24,'hh24'); v_day := to_char(sysdate,'fmdd'); DBMS_OUTPUT.PUT_LINE(v_hour); v_sqlStr := 'insert into fy_day_'||v_day||'( select login_name,trunc(sysdate,''hh24''),lab_ip,sum(time_duration) from fy_detail_'||v_day||' where logout_date >= trunc(sysdate-1/24,''hh24'') and logout_date < trunc(sysdate,''hh24'') group by login_name,lab_ip)';EXECUTE IMMEDIATE v_sqlStr;END;
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -