oracle for语句

begin
declare  cursor cur is select menu_code,menu_en,id from t_bd_menu where menu_name in ('员工请假申请'
,'员工加班申请'
,'每月考勤表'
,'上岗通知单'
,'员工入职面谈申请'
,'员工转正满意度调查'
,'员工转正申请'
,'员工调动申请'
,'员工整改申请'
,'岗位竞聘推荐自荐表'
,'员工离职交接申请'
,'员工离职申请'
,'离职通知单'
,'离职证明'
,'员工意见反馈'
,'员工绩效面谈申请'
,'员工绩效考核'
,'员工绩效申诉'
,'个人租房申请'
,'每月薪资表'
,'员工薪资异议');
begin
    for xx in cur
       loop
    --处理
dbms_output.put_line('update t_bd_menu set menu_en='''|| xx.menu_en||''' where menu_code='''|| xx.menu_code||''' and id='||xx.id||';');
    end loop;
end;
end;

 

begin
declare  cursor cur is select e.id,e.account_sn from strongerp.t_fi_ea_accountexpense e where e.account_sn in(select e.account_sn from strongerp.t_fi_ea_accountexpense e group by e.account_sn 
having count(*)>1 ) order by e.account_sn desc;
i number;
j number;
begin
  i:=1;
  j:=100;
    for xx in cur
       loop
    --处理
   
    if((i mod 2)=1) then
    j:=j+1;
dbms_output.put_line(' strongerp.t_fi_ea_accountexpense set e.account_sn='''|| to_number(150405117)+j||''' where id='||xx.id||';');
end if;
 i:=i+1;
    end loop;
end;
end;