用存储过程插入10万条测试数据的sql

declare
  id varchar2(36);
begin
  for i in 1..100000
    loop
      id := '8a035883348d33f501649197' || lpad(to_char(i),8,'0');
          insert into RECEIVER_INFO (ID, CREATE_NAME, CREATE_BY, CREATE_DATE, UPDATE_NAME, UPDATE_BY, UPDATE_DATE, SYS_ORG_CODE, SYS_COMPANY_CODE, BPM_STATUS, RECEIVER_NAME, CARD_NUM, PHONE_NUM, CONSTRUCT)
          values (id, '管理员', 'admin', '17-7月 -19 06.03.27.868000 下午', null, null, null, 'A09', 'A09', '1', '苏大强', '393256321445213256', '16958442365', 'A02');
    end loop;
end;

本来想着id用生成的UUID，没有百度到，后来 搜到Oracle生成UUID是这样

select sys_guid() from dual;