批量插入数据:
declare
recordnumber number(10):=100;
begin
whlie recordnumber >0 loop
insert into LYTESTTABLE(name,age,sex) values (‘liu’,23,‘male’);
recordnumber:=recordnumber-1;
end loop;
end;
12-16
批量插入数据:
declare
recordnumber number(10):=100;
begin
whlie recordnumber >0 loop
insert into LYTESTTABLE(name,age,sex) values (‘liu’,23,‘male’);
recordnumber:=recordnumber-1;
end loop;
end;