day.sql

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

DECLARE
	dd			BINARY_INTEGER;
	v_sqlStr	VARCHAR2(900);	
BEGIN
	select to_char(sysdate,'FMDD') into dd from dual;
	v_sqlStr:='create table fy_day_'||dd||'(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;