1.下面的一种方法明显是错的:for startNum in 1..10 loop --这种方式startNum不会循环到2
--这里要重新初始化beginTime;
while (beginTime <= nowTime) loop
insert into targetTable (num,tmpTime) values (stratNum,beginTime);
beginTime := f_dateadd(beginTime,1,2);--while循环结束后,beginTime 已经比nowTime大了,事实上2到10都循环到了,只不过此时beginTime <= nowTime不满足条件
end loop;
end loop;
--这里要重新初始化beginTime;
while (beginTime <= nowTime) loop
insert into targetTable (num,tmpTime) values (stratNum,beginTime);
beginTime := f_dateadd(beginTime,1,2);--while循环结束后,beginTime 已经比nowTime大了,事实上2到10都循环到了,只不过此时beginTime <= nowTime不满足条件
end loop;
end loop;
case sortNum
when 1 then
sortName := '00000701';
countNum := 100;
when 2 then
sortName := '00000702';
countNum := 250;
...
else ...;
end case;
end loop;