批量造数SQL
批量造数SQL
create or replace procedure YTDATA IS
i numbei;
z number;
begin
z:= 410621199407777
from i in 1 .. 10loop
begin
---表导出SQL--
insert into 表名(ID,.......)
values (sys_guid(),'','','','',)
z:= z+1;
commit;
end;
end loop
end YTDATA
...
原创
2021-01-03 10:29:03 ·
476 阅读 ·
0 评论