Oracle 批量修改语句 笔记

1.创建变量
2.查询出需要修改的列 数据
3. 赋值循环变量 i  in  查询出的数据
4. 赋值自定义变量 b   =   想要修改的值
5.  update  tablename  set  修改列 = 变量b  where  修改列的数据 =  循环变量 i；

declare 
       b varchar2(35);
begin 
   for i in  (select card_num from (select * from buyer b where b.card_num like 'X%' and card_type = 'xxx')) loop
     b := substr(i.card_num,3);
     update buyer b1 set b1.card_num = b where b1.card_num = i.card_num;
     commit;
    end loop;
end;