oracle merge

oracel merge用法，只贴图不说话

 

merge into  a

using (select i.custid, i.contphonecountry, i.contphonecitycode,i.contphone

         from  i) b

on (a.custid = b.custid)

when matched then

  update

     set a.contphone = b.contphonecountry || ' ' || b.contphonecitycode || ' ' ||b.contphone

   where a.contphone is not null;