美文网首页
Oracle merge into :无法更新 ON 子句中引

Oracle merge into :无法更新 ON 子句中引

作者: Jesse4023 | 来源:发表于2022-04-10 17:38 被阅读0次

MERGE INTO ZHXX T1
            USING ACCOUNTS_TEMP T
            ON 
           ( T1.ACCNO = T.ACCNO AND   (T.STATE='9' OR T.STATE='10'  ) AND  (T1.STATE IS NULL) )
            WHEN MATCHED THEN
                UPDATE
                    SET
                        T1.state = T.state,
                        T1.memo = T.memo

改为

MERGE INTO ZHXX T1
            USING ACCOUNTS_TEMP T
            ON ( T1.ACCNO = T.ACCNO AND (T.STATE='9' OR T.STATE='10' ) ) 
            WHEN MATCHED THEN
                UPDATE
                    SET
              T1.MEMO = DECODE(T1.MEMO, NULL, T.MEMO, T1.MEMO),
                     T1.STATE = DECODE(T1.STATE, NULL,T.STATE,T1.STATE)
                                         -- DECODE(变量S,如果S=NULL,S=1,否则S=2)
                        

相关文章

网友评论

      本文标题:Oracle merge into :无法更新 ON 子句中引

      本文链接:https://www.haomeiwen.com/subject/jcnvsrtx.html