oracle批量插入测试数据

2019独角兽企业重金招聘Python工程师标准>>>

create table mytable(

       uuid varchar2(64) primary key,

       nameserial varchar2(128),

       idserial number

);

insert into mytable values(sys_guid(), '名字1', 55.5);

select * from mytable;

declare

  i number;

  len number;

begin

  i := 0;

  len := 100;

  while i < len  loop

    insert into mytable values (sys_guid(), CONCAT('名字', i), i);

    i  := i + 1;

  end loop;

  commit; -- 提交一下

end;

转载于:https://my.oschina.net/u/555061/blog/489336