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语句,大大减少代码量。