--批量更新 快速游标法
BEGIN
FOR cr IN (
SELECT
D .name
FROM
XXXX
WHERE
D .numIN (select tz.num from XXXX tz
WHERE tz.xzz_dzbm not in
(select a.xzz_dzbm
from XXXX a
where a.flag != 3 and a.xzz_dzbm is not null)
and tz.djbgbs != 3) and d.xzz_dzbm is not null
) loop UPDATE XXXX T
SET t.name=cr.name
WHERE
T .id= cr.id;
END loop ;
END ;
--查看效果
select * from 表名;