关于merge into

[htht555]

merge into ${tableNameA} X
using(SELECT 2 AS CELL,2 AS DATAQUANTITY FROM dual) N
on (X.CELL=N.CELL)
when matched then
update SET X.DATAQUANTITY=N.DATAQUANTITY
when not matched then
insert
values(
N.LATITUDE,
N.DIR,
N.CELLTYPE,
N.CELL,
N.DATAQUANTITY
);
COMMIT; 我是这样写的，但是一直无效字符，N.LATITUDE,取不到好像N.#{LATITUDE}改这样也没用，什么问题啊？

[htht555]

@卖水果的net

[卖水果的net]

-- 果然是存在了隐匿转换

using(SELECT 2 AS CELL,2 AS DATAQUANTITY FROM dual) N

--改成，下面的，加单引号

using(SELECT '2' AS CELL,'2' AS DATAQUANTITY FROM dual) N

[卖水果的net]

把 tableNameA 表结构，给一下； 可能是存在了隐性转换了；