oracle中使用游标实现多重循环

oracle中游标的使用能降低我们很多工作量，这里我们将介绍有标的嵌套循环，帮助我们减少代码量：

declare
 cursor c_emp is
             select t.zxbs from IPENTITY t;
 cursor c2_emp is
             select t.protype from ORGSERVMAP t;   
 Begin  
  for c in c_emp loop
    for c2 in c2_emp loop
    v_Tmp_SQL := 'SELECT COUNT(1)  FROM b WHERE a.orgaddr =   
                  b.ydmobile and b.dsbs=''' ||c.zxbs || '''    
                  and a.protype = ''' || c2.protype ||
                  ''' and trunc(recvtime,''dd'') = ''' ||
                  v_tSelectDate || '''';

  execute immediate to_char(v_Tmp_SQL)
   INTO sm_everyup_recv;

   end loop;
   end loop;
   COMMIT;
  end;

此处经过循环输出可以输出所有我们需要的sql语句，大大减少代码量。