oracle merge

MERGE INTO EHR_STAFF_ATTEND_DETAIL A 
USING (SELECT 'LOVE001' AS STAFF_ID,
 2 AS ATTEND_DETAIL_ID,
 '1011' AS ATTEND_NO, 
'02' AS ATTEND_STYLE, 
'41' AS PERMUTE_ID, 
'1' AS IS_VALID, 
USER AS CREATED_BY,
 USER AS UPDATED_BY, 
SYSDATE AS DATE_CREATED, 
SYSDATE AS DATE_UPDATED 
FROM DUAL) B ON (A.STAFF_ID = B.STAFF_ID) 
WHEN MATCHED THEN
 UPDATE SET 
A.ATTEND_NO = B.ATTEND_NO, 
A.ATTEND_STYLE = B.ATTEND_STYLE, 
A.PERMUTE_ID = B.PERMUTE_ID, 
A.IS_VALID = B.IS_VALID, 
A.UPDATED_BY = B.UPDATED_BY, 
A.DATE_UPDATED = B.DATE_UPDATED 
WHEN NOT MATCHED THEN 
INSERT (A.ATTEND_DETAIL_ID,A.STAFF_ID,A.ATTEND_NO,A.ATTEND_STYLE,A.PERMUTE_ID,A.IS_VALID,A.CREATED_BY,A.UPDATED_BY,A.DATE_CREATED,A.DATE_UPDATED) 
VALUES (B.ATTEND_DETAIL_ID,B.STAFF_ID,B.ATTEND_NO,B.ATTEND_STYLE,B.PERMUTE_ID,B.IS_VALID,B.CREATED_BY,B.UPDATED_BY,B.DATE_CREATED,B.DATE_UPDATED);

 MERGE 使用

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值