detail.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 datazf_'||dd||'(login_name varchar2(32),login_date date,logout_date date,lab_ip varchar2(32),time_duration number(10))';
EXECUTE IMMEDIATE v_sqlStr;
END;