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;
/
2022-04-01
[Oracle]Loop insert SQL
- 97
- 0