批量造数SQL
create or replace procedure YTDATA IS
i numbei;
z number;
name VARCHAR2(50)
begin
z:= 410621199407777
from i in 1 .. 10loop
select floor(dbms_random.value(1000,99999999),2)into m from dual ---随机数
begin
---表导出SQL--
insert into 表名(ID,.......)
values (sys_guid(),'','',m,'',)
z:= z+1;
commit;
end;
end loop
end YTDATA
–仅供自己参考,后续待改