oracle存储过程循环修改

张兴康

1. create or replace procedure update
   
2. is
   
3. cursor c1 is
   
4. select s.id as column1,t.huzhu_name as column2  from table1 s,table2 t  where t.id=s.apply_id ;
   
5. begin
   
6. for r1 in c1 loop
   
7. update table1 a set a.huzhu_name=r1.column2 where a.id=r1.column1;
   
8. commit;
   
9. end loop;
   
10. end update;

复制代码

张兴康

fteair

张兴康

fteair

张兴康

fteair

张兴康