PLSQL总结

批量插入数据:
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;