oracle中循环插入语句

DECLARE
i number:=30000;
BEGIN
for i in 1..100 loop

insert into Maternal_Info(id,sjh,bbsr,cf)

values(sys_guid(),'1357050****','2014-12-03','是');

dbms_output.put_line(i);
end loop;
END;

posted @ 2014-12-01 17:28  包包酱  阅读(1709)  评论(0)    收藏  举报