读书人

oracle 循环安插数据

发布时间: 2012-07-30 16:19:05 作者: rapoo

oracle 循环插入数据

declare
v_LoopCounter Binary_Integer:=1;
begin
loop
insert into r_examquestion(questioncontent, questiontypecode, sectionid, catalogid, stagecode,
?subjectcode, versioncode, gradecode, depid, title,Operno,Ispersondelete
?) values
?('aaa', '004', '0000000433', '0000000201', '03',
?'001', '0101', '001', '0003230', '000000001','000000001','0'
?);
v_LoopCounter:= v_LoopCounter+1;
exit when v_LoopCounter=1000000;
end loop;
end;

读书人网 >其他数据库

热点推荐