declare
m number :=100000;
begin
for x in 0..m loop
insert into wait_deal_mess
(id,
huhao,
tel,
type,
mcontent,
addtime,
state,
smscount,
person,
ltdno,
systemid,
sendinterface)
values
(waitdealmess_sequence.nextval,
0,
'139' || lpad(x,8,'0') ,
11,
'你有一项编号为3122的事务需要处理。',
sysdate,
0,
1,
'1000',
'',
'mis',
'XXXXX');
end loop;
end;