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;