17,140
社区成员




BEGIN
for cur1 in (select *
from ZHUANMA) loop
update BJDZ set BJMC = REPLACE(BJMC, cur1.PREZF, cur1.aferzf) ;
commit;
END LOOP;
end;
感谢chengccy指点。SELECT T.BJMC, REPLACE(BJMC, PREZF, AFTERZF)
FROM BJDZ T
LEFT JOIN ZHUANMA T1
ON INSTR(BJMC, PREZF) > 0
update :
UPDATE BJDZ T
SET T.BJMC =
(SELECT MAX(REPLACE(BJMC, PREZF, AFTERZF))
FROM ZHUANMA T1
WHERE INSTR(BJMC, PREZF) > 0)