--插入
declare
dlCd varchar(50);
begin
for i in 1 .. 10000
loop
select '7.5.'||to_char(100000 + i) into dlCd from dual;
insert into tablename(dl_cd) value (dlCd);
end loop;
commit;
end;
--删除
declare
dlCd varchar(50);
begin
for i in 1 .. 10000
loop
select '7.5.'||to_char(100000 + i) into dlCd from dual;
delete from tablename where dl_cd = dlCd;
end loop;
commit;
end;