oracle 之 for循环表

 

代码 
create table tm_lzh as
SELECT 'a1' c1,'b1' c2 FROM dual
union all
SELECT 'a2' c1,'b2' c2 FROM dual
union all
SELECT 'a3' c1,'b3' c2 FROM dual
union all
SELECT 'a4' c1,'b4' c2 FROM dual
union all
SELECT 'a5' c1,'b5' c2 FROM dual
union all
SELECT 'a6' c1,'b6' c2 FROM dual;

DECLARE
a varchar2(10);
b varchar2(10);
begin
for i in(select c1,c2 from tm_lzh) loop
    a:=i.c1;
    b:=i.c2;
    dbms_output.put_line('i.c1='||i.c1);
    dbms_output.put_line('i.c2='||i.c2);
    dbms_output.put_line('a='||a);
    dbms_output.put_line('b='||b);
  end loop;
end;
执行结果

oracle 之 for循环表_for循环

 

世风之狡诈多端，到底忠厚人颠扑不破； 末俗以繁华相尚，终觉冷淡处趣味弥长。