oracle双重循环

select count(*) from T_USER_DRAWACTIVITY;
--查询A
select * from T_USER_DRAWACTIVITY t WHERE t.activityPic LIKE '%img%';
--查询B
select * from T_USER_DRAWRULE t where t.drawRuleId LIKE '%rulezhujian%';
--删除A
DELETE FROM T_USER_DRAWACTIVITY t WHERE t.activityPic LIKE '%imgssssss%';
--删除B
DELETE FROM T_USER_DRAWRULE t where t.drawActivityId LIKE '%test%';

DECLARE
x number; --声明变量
BEGIN
x:=0; --给初值
FOR V_INDEX IN 01..10 LOOP
insert into T_USER_DRAWACTIVITY
(ACTIVITYID,
activityPic,
ACTIVITYNAME,
GOODSPIC,
DRAWPOINTAMOUNT,
BINGOTIMES,
BEGINTIME,
ENDTIME,
MAXPOINTAMOUNT,
ISDELETE,
STATUS,
GOODSNUM,
CREATETIME,
CREATEUSER,
UPDATETIME,
UPDATEUSER,
REMARK)
values
('choujiangzhujian' || V_INDEX,
'img'|| V_INDEX,
'choujiangname'|| V_INDEX,
'goodspic'|| V_INDEX,
1,
1,
to_number(to_char(sysdate,'yyyymmddhh24miss')),
20170331112037,
10000,
0,
0,
10000,
to_number(to_char(sysdate,'yyyymmddhh24miss')),
'admin',
to_number(to_char(sysdate,'yyyymmddhh24miss')),
'admin' ,'备注'||V_INDEX);

FOR R_INDEX IN 01..10 LOOP
x:=x+1;
insert into T_USER_DRAWRULE
(drawRuleId,drawActivityId,bingoNum)
values
(
'rulezhujian' || x,
'choujiangzhujian' || V_INDEX,
R_INDEX
);
END LOOP;

END LOOP;
END;