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;
Oracle 批量修改语句 笔记
最新推荐文章于 2024-07-18 19:28:01 发布