例子如下:
begin
for x in 1..30000 loop
insert into app_subsc_ctrl c
(c.gmt_start,c.gmt_end,c.Status,c.app_subsc_ctrl_id,c.subsc_user_id,c.app_instance_id,c.app_id,c.cancel_status,c.cancelled_times)
values(to_date('2008-01-01','yyyy-mm-dd'),to_date('2008-01-01','yyyy-mm-dd'),'1','ascizhaowei'||to_char(x),'suzhaowei'||to_char(x),
'aiizhaowei'||to_char(x),
'aidzhaowei'||to_char(x),0,0);
end loop;
end;*/