批量安插测试数据sql

批量插入测试数据sql
DECLARE
i INT;
BEGIN
i := 1;
WHILE(i < 100)
LOOP
   i := i + 1;
  begin
  INSERT INTO test1(ID, name,remark) VALUES(i, '姓名' || i,'remark'||i);
  commit;
  exception
  when others then
  rollback;
  end;
END LOOP;
END;