备份表的操作，按照一个表的最新数据更新另一个表的某个字段

 

公司需求表的更换片区之后操作整个表的更新

 

买卖需求

createtable mm_xqinfobak asselect  *from  mm_xqinfo

 

update   (select  /*+use_hash(a,b)*/  a.duty_deptnameall  as a5,b.deptnameall  as b5

           from  mm_xqinfo a, oy_department  b  where b.deptid = a.duty_deptid  )     set a5=b5 ;

commit;

 

 

租赁需求

 

createtable zl_xqinfobak asselect  *from  zl_xqinfo

 

update   (select  /*+use_hash(a,b)*/  a.duty_deptnameall  as a5,b.deptnameall  as b5

           from  zl_xqinfo a, oy_department  b  where b.deptid = a.duty_deptid  )     set a5=b5 ;

commit;

 

 

买卖合同

 

createtable mm_cjinfobak asselect  *from  mm_cjinfo

 

update   (select  /*+use_hash(a,b)*/  a.cj_deptnameall  as a5,b.deptnameall  as b5

           from  mm_cjinfo a, oy_department  b  where b.deptid = a.cj_deptid  )     set a5=b5 ;

commit;

 

 

租赁合同

createtable zl_cjinfobak asselect  *from  zl_cjinfo

 

update   (select  /*+use_hash(a,b)*/  a.cj_deptnameall  as a5,b.deptnameall  as b5

           from  zl_cjinfo a, oy_department  b  where b.deptid = a.cj_deptid  )     set a5=b5 ;

commit;

 

买卖房源

createtable mm_fyinfobak asselect  *from  mm_fyinfo

 

update   (select  /*+use_hash(a,b)*/  a.duty_deptnameall  as a5,b.deptnameall  as b5

           from  mm_fyinfo a, oy_department  b  where b.deptid = a.duty_deptid  )     set a5=b5 ;

commit;

 

 

 

租赁房源

createtable zl_fyinfobak asselect  *from  zl_fyinfo

 

update   (select  /*+use_hash(a,b)*/  a.duty_deptnameall  as a5,b.deptnameall  as b5

           from  zl_fyinfo a, oy_department  b  where b.deptid = a.duty_deptid  )     set a5=b5 ;

commit;