begin
for i in 1000000 ..12000000
loop
insert into qpxx(qpxtbh,ssdw,djjg,djh,scjyrq,xcjyrq,scrq,ccbh,cjsj,jzrq) values (
seq_qpxx_qpxtbh.nextval,
'充装站001' ,
'质量技术监督局',
i,
'2012-01-10',
'2016-01-10',
'2010-12-01',
'1000'+i,
'2012-12-15',
'2012-12-23'
);
end loop;
commit;
end;
oracle循环插入数据
最新推荐文章于 2022-10-20 09:57:54 发布