month.sql

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

DECLARE
	mm			BINARY_INTEGER;
	v_sqlStr	VARCHAR2(900);
BEGIN
	select to_char(sysdate,'MM') into mm from dual;
	v_sqlStr := 'create table fy_month_'||mm||'(login_name varchar2(32),logout_date date,lab_ip varchar2(32),time_duration number(10),primary key(login_name,lab_ip,logout_date))';
EXECUTE IMMEDIATE v_sqlStr;
END;