?? insert_to_year.sql
字號(hào):
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;
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -