nvl
nvl2
nullif
coalesce
decode
merge into v5_tenant_repair_appl_follow f
using (select '2018111219530688462' ra_id,'test' ra_staffcode from dual) n
on(f.ra_id=n.ra_id)
when matched then
update set f.ra_staffcode=n.ra_staffcode
when not matched then
insert values(n.ra_id,n.ra_staffcode)
后面有时间说怎么弄