create or replace procedure UpdateTestData
is
j number;
dept_min_no number;
dept_max_no number;
begin
--更新部门表
delete from test_dept;
for i in 1..10
loop
insert into test_dept(dept_name,f_deleteflag) values('部门'||i,0);
commit;
end loop;
--更新用户表
--dept_min_no:=0;
--dept_max_no:=0;
select min(f_id) into dept_min_no from test_dept;
select max(f_id) into dept_max_no from test_dept;
delete from test_user;
for i in 1..30
loop
select floor(dbms_random.value(dept_min_no,dept_max_no)) into j from dual;
insert into test_user(f_id,username,userpwd,age,sex,birthday,telephone,address,email,memo,deptid,realname,f_deleteflag)
values(i,'a'||i,'123456',i+20,'男',sysdate-365*i,'13500112233','北京市海淀区上地信息大厦',j||'@163.com','备注备注',j,'张三'||i,0);
commit;
end loop;
end UpdateTestData;