oralce 更新或删除

merge into ECC_YWDP_KPI a
using ( select to_date(#{selectTime} ,'yyyymmddHH24mi') as select_time, #{datares} as datares from dual ) b
    on (a.select_time = b.select_time and a.datares = b.datares )
when not matched then
    insert  (id,aveg_time,select_time,trade_count,succ_count,res_count,datares)
    values (#{id},#{avegTime},to_date(#{selectTime},'yyyymmddHH24mi'),#{tradeCount},#{succCount},#{resCount},#{datares})
when matched then
    update set
    aveg_time = aveg_time + #{avegTime},
    trade_count = trade_count+#{tradeCount},
    succ_count = succ_count+#{succCount},
    res_count = res_count+#{resCount}
    where select_time = to_date(#{selectTime} ,'yyyymmddHH24mi') and datares = #{datares}