merge into MALL_MER_SHOP_TURNOVER_DETIL s
using (select *
from (select '8202104130000003' as mchtNo,
'2021-04-15 09:08:42.0' as transDate,
'100.00' as transAmt,
'A006' as txnAccType,
'0.00' as stlmFee,
'21021041509093343019857092000964' as transSsn,
'01'as transType,
'100.00' as stlmAmt,
'30233169295902221068822938183784'as orderId,
'0.00' as feeReduct,
'00' as transStat
from dual)) t
on (s.PAYNO = t.transSsn)
when matched then
update
set s.TRANSDATE = t.transDate,
s.PAYAMOUNT = t.transAmt,
s.PAYCHANNEL = t.txnAccType,
s.FEEAMOUNT = t.stlmFee,
s.TRANSTYPE = t.transType,
s.CREATETIME = sysdate,
s.INCOMEAMOUNT = t.stlmAmt,
s.FEEREDUCT = t.feeReduct,
s.TRANSSTAT = t.transStat
when not matched then
insert
(s.SHOPID,
s.TRANSDATE,
s.PAYAMOUNT,
s.PAYCHANNEL,
s.FEEAMOUNT,
s.PAYNO,
s.TRANSTYPE,
s.CREATETIME,
s.INCOMEAMOUNT,
s.ORDERID,
s.FEEREDUCT,
s.TRANSSTAT)
values
((select mcseq from mall_mer_shrz where mer_cifno = t.mchtNo),
t.transDate,
t.transAmt,
t.txnAccType,
t.stlmFee,
t.transSsn,
t.transType,
sysdate,
t.stlmAmt,
t.orderId,
t.feeReduct,
t.transStat);
报错:
使用merge into时候insert into 报错
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-
1条回答 默认 最新
悬赏问题
- ¥15 这个主板怎么能扩出一两个sata口
- ¥15 不是,这到底错哪儿了😭
- ¥15 2020长安杯与连接网探
- ¥15 关于#matlab#的问题:在模糊控制器中选出线路信息,在simulink中根据线路信息生成速度时间目标曲线(初速度为20m/s,15秒后减为0的速度时间图像)我想问线路信息是什么
- ¥15 banner广告展示设置多少时间不怎么会消耗用户价值
- ¥16 mybatis的代理对象无法通过@Autowired装填
- ¥15 可见光定位matlab仿真
- ¥15 arduino 四自由度机械臂
- ¥15 wordpress 产品图片 GIF 没法显示
- ¥15 求三国群英传pl国战时间的修改方法