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