这个sql能修改成oracle适配的语法吗？

[卑鄙徐]

<update id="batchUpdateFundNumber" parameterType="list" databaseId="oracle">
    BEGIN
    <foreach collection="list" item="item" index="index">
        update mad_project t
        left join mad_project_aux m on t.mad_id = m.mad_id set
        t.approval_amt=#{item.approvalAmt},
        t.acitem19_code=#{item.acitem19Code},
        m.fund_number=#{item.fundNumber}
        where
        t.agy_code=#{item.agyCode}
        and t.mof_div_code=#{item.mofDivCode}
        and t.mad_code=#{item.madCode}
        and t.pro_status=#{item.proStatus}
        and t.fiscal=#{item.fiscal};
    </foreach>
    END;
</update>

update mad_project t left join mad_project_aux m on t.mad_id = m.mad_id set t.approval_amt=#{item.approvalAmt}, t.acitem19_code=#{item.acitem19Code}, m.fund_number=#{item.fundNumber} where t.agy_code=#{item.agyCode} and t.mof_div_code=#{item.mofDivCode} and t.mad_code=#{item.madCode} and t.pro_status=#{item.proStatus} and t.fiscal=#{item.fiscal};

[daidaixiaolaodi]

UPDATE mad_project t INNER JOIN mad_project_aux m ON t.mad_id = m.mad_id SET t.approval_amt = #{item.approvalAmt}, t.acitem19_code = #{item.acitem19Code}, m.fund_number = #{item.fundNumber} WHERE t.agy_code = #{item.agyCode} AND t.mof_div_code = #{item.mofDivCode} AND t.mad_code = #{item.madCode} AND t.pro_status = #{item.proStatus} AND t.fiscal = #{item.fiscal}

[2301_79207080]

http://k.qi.wiki/news/gwrp492516.html
http://k.qi.wiki/news/z6rf584307.html

[兜兜风灬]

oracle关联更新
https://blog.csdn.net/cqt3589/article/details/135912690