oracle : 无法更新 ON 子句中引用的列

下面这个句子总是无法执行,提示:无法更新 ON 子句中引用的列: "PT"."GROUP_CODE"

原因:on中 "PT"."GROUP_CODE"已经用作了匹配,无法在update里又做更改,需要去掉匹配才能做update操作。

merge into t_procedure_test pt
using (select ro.route_groupid, ro.group_next group_name,tec.TECHNICSID,tec.TECHNICSNAME
--,tec.MODEL_CODE,tec.ENABLED,tec.MO_NUMBER,tec.ROUTE_CODE, ro.group_code
from t_smo_technics tec ,t_co_route_control ro
where tec.MODEL_CODE='1002000005051' and tec.route_code=ro.route_code and ro.group_next='NBPACK-FINAL-TEST') gro
on (gro.TECHNICSID=pt.TECHNICS_ID and gro.route_groupid=pt.GROUP_CODE)
when matched then
update set pt.GROUP_CODE='Test'
when not matched then
insert (TECHNICS_ID,TECHNICS_NAME,group_name,group_code,test_item_id) values(000,'test','test','000',000);

posted @ 2019-03-28 14:36  hanje  阅读(2684)  评论(0编辑  收藏  举报