CREATE OR REPLACE procedure NH_ZCGL.addDeviceInfo
is
begin
for x in 20001…50000
loop
begin
INSERT INTO NH_ZCGL.JC_DEVICE
(DEVICEID, DEVICENAME, DEVICENO)
VALUES(fun_createuid(), ‘笔记本测试数据0930_’||x, ‘H120019011600’||(2000+x));
end;
end loop;
end addDeviceInfo;
执行存储过程:
CALL addDeviceInfo();