for循环加入测试数据:
declare i number :=15;
begin
for num in 1..i loop
insert into addinfo("oid","uid",ONAME,CREATEDATE) values(num,num,'FF'||num,sysdate());
end loop;
commit;
end;
for循环加入测试数据:
declare i number :=15;
begin
for num in 1..i loop
insert into addinfo("oid","uid",ONAME,CREATEDATE) values(num,num,'FF'||num,sysdate());
end loop;
commit;
end;