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;
Oracle中循环插入测试数据
最新推荐文章于 2024-03-12 11:24:23 发布