简单的数据制造方法:
一
declare
i int;
begin
for i in 1..1000000 loop
insert into t_push_smresponselog values
(i,'1311'||LPAD(i,7,'0'),'是',to_date('2013-7-19 00:00:00','yyyy-mm-dd hh24:mi:ss')+(i/24/60/60) ,'1','42','','7','1','','','','','10658099020027','5','10009999','','','','0');
end loop;
commit;
end;
/
二
--向黑名单表中插入10100000001,10100010001之间的号码
declare
i int;
begin
for i in 1..2000 loop
insert into t_push_blackuser
(
msisdn,
opertime,
limittype,
operator,
channeltype,
usrruleid,
sequence,
accounttype,
provincelist,
validtime,
invalidtime)
values
((select trunc(dbms_random.value(10100000001,10100010001)) from dual),
'20141211160543',
'0',
'sysadmin',
'1',
'',
'',
'',
'',
'',
''
);
end loop;
commit;
end;
/