Oracle中循环插入测试数据

declare
  maxrecords constant int:=100;
  i int :=1;
begin
  for i in 1..maxrecords loop
      insert into T_SMS_TO_MMS_DIY_DATA(ID,MOBILE_NO,CONTENT,LINKID,INSERT_TIME,IS_FETCH,IS_SEND,SEND_TIME)
      values(i,'187********','天天快乐，天天开心','11544124488326708964',to_date('31-12-2009 14:14:37', 'dd-mm-yyyy hh24:mi:ss'),'0','0',to_date('31-12-2009 14:14:37', 'dd-mm-yyyy hh24:mi:ss'));
  end loop;
dbms_output.put_line('成功录入数据');
commit;
end;