[Oracle]Loop insert SQL

  • 97
  • 0

Loop insert SQL

begin
for loopcnt in 1 .. 100 loop
insert into ts.device (DEVICE_SEQ, DEVICE_ID, UID, TOKEN)
values (1000+loopcnt, '015e166d215e166d2'||loopcnt, 'TEST', 'dwUmDOn14-Q');
end loop;
commit;
end;
/