oracle 循环插入多条数据
insert into test
select 491061+rownum ,'0'||(100+rownum),round(dbms_random.value(600001,999999)),'','','','','','','',null,0,-1,'jg','','0',0,'','','' from dual
connect by rownum<=100
发布时间： 2012-09-04 14:19:30 作者： rapoo
oracle 循环插入多条数据
insert into test
select 491061+rownum ,'0'||(100+rownum),round(dbms_random.value(600001,999999)),'','','','','','','',null,0,-1,'jg','','0',0,'','','' from dual
connect by rownum<=100