insert_to_month.sql

来自「ERP管理功能」· SQL 代码 · 共 16 行

DECLARE
	v_day		VARCHAR2(2);
	v_month		VARCHAR2(2);
	v_sqlStr	VARCHAR2(900);	
BEGIN
	v_day    := to_char(sysdate-1,'fmdd');
	v_month  := to_char(sysdate,'fmmm');
	DBMS_OUTPUT.PUT_LINE(v_day);
	v_sqlStr := 'insert into fy_month_'||v_month||'(
	select login_name,trunc(sysdate-1,''fmdd''),lab_ip,sum(time_duration) from fy_day_'||v_day||'
		where logout_date >= trunc(sysdate-1,''fmdd'')
		and logout_date < trunc(sysdate,''fmdd'')
		group by login_name,lab_ip)';
EXECUTE IMMEDIATE v_sqlStr;
END;