merge into t5_prod_calendar a using
(select :sys_date as workday, :prod_code prod_code , :tano tano from dual) b
on (a.prod_code = b.prod_code and a.tano = b.tano and a.sys_date = b.workday)
when matched then
update set
a.is_apply_date = :is_apply_date,
a.is_apply_ack_date = :is_apply_ack_date,
a.is_redeem_date = :is_redeem_date,
a.is_redeem_ack_date = :is_redeem_ack_date,
a.legal_code = :legal_code,
a.apply_cfm_date = :apply_cfm_date,
a.redeem_cfm_date = :redeem_cfm_date
when not matched then
insert (
tano,
prod_code,
sys_date,
is_subs_date,
is_establish_date,
is_value_date,
is_apply_date,
is_apply_ack_date,
is_redeem_date,
is_redeem_ack_date,
is_register_date,
is_convert_date,
is_winding_date,
is_pay_date,
is_end_date,
legal_code,
apply_cfm_date,
redeem_cfm_date
) values (
:tano,
:prod_code,
:sys_date,
:is_subs_date,
:is_establish_date,
:is_value_date,
:is_apply_date,
:is_apply_ack_date,
:is_redeem_date,
:is_redeem_ack_date,
:is_register_date,
:is_convert_date,
:is_winding_date,
:is_pay_date,
:is_end_date,
:legal_code,
:apply_cfm_date,
:redeem_cfm_date
)
uj5u.com熱心網友回復：
on duplicate key update轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/253274.html
標籤：疑難問題