declare i number; begin i := 2; while (i <= 10) loop insert into Tgongwen(gid,fariqi,neibuyonghu,reader,title) values(i,to_date('2004-2-5','YYYY-MM-DD'),'通信科','通信科,办公室,王局长,刘局长,张局长,admin,刑侦支队,特勤支队,交巡警支队,经侦支队,户政科,治安支队,外事科','这是最先的25万条记录'); i := i + 1; end loop; commit; end;
动一下脑子再问问题啥
i number;
begin
i := 2;
while (i <= 10)
loop
insert into Tgongwen(gid,fariqi,neibuyonghu,reader,title) values(i,to_date('2004-2-5','YYYY-MM-DD'),'通信科','通信科,办公室,王局长,刘局长,张局长,admin,刑侦支队,特勤支队,交巡警支队,经侦支队,户政科,治安支队,外事科','这是最先的25万条记录');
i := i + 1;
end loop;
commit;
end;
先了解一下oracle支持的sql语法吧