今天在执行一个meger sql 时,报了下面的错误:
ORA-38104: 无法更新 ON 子句中引用的列: "A"."CAMPAIGNID" ,原来是在 on 中的列不能更改
SQL>
merge into cfgbk.huang1 a
using cfgbk.huang b
on (a.campaignid = b.campaignid and a.userid = b.userid )
when matched then
update set
a.campaignid = b.campaignid,
a.userid = b.userid,
a.lastrefreshdate = b.lastrefreshdate,
a.dailycount = b.dailycount,
a.monthlycount = b.monthlycount,
a.totalcount = b.totalcount,
a.freechance = b.freechance,
a.handselchance = b.handselchance
when not matched then
insert (
a.campaignid,
a.userid,
a.lastrefreshdate,
a.dailycount,
a.monthlycount,
a.totalcount,
a.freechance,
a.handselchance)
values
(
b.campaignid,
b.userid,
b.lastrefreshdate,
b.dailycount,
b.monthlycount,
b.totalcount,
b.freechance,
b.handselchance)
ORA-38104: 无法更新 ON 子句中引用的列: "A"."CAMPAIGNID"