BEGIN
FOR L_RECORD IN (select id from B_FA_FIN_A_D_S_201215)
LOOP
UPDATE B_FA_FIN_A_D_S_201215
SET id = sys_guid()
WHERE id = L_RECORD.id;
END LOOP;
commit;
END;
orcle中循环修改主键id
最新推荐文章于 2023-05-09 10:23:41 发布