Script for synchronizing two tables

Script for synchronizing two tables

 

table 1 : rec_exp

table 2 : tm

 

name = common column in both tables

arn = common in both tables

Update rec_exp a

Set name= (select name from tm where arn=a.arn);