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;