Oracle数据库比对更新数据

SQL UPDATE语句

UPDATE table1 t1   SET (name, desc) = (SELECT t2.name, t2.desc                         FROM table2 t2                        WHERE t1.id = t2.id) WHERE EXISTS (    SELECT 1      FROM table2 t2     WHERE t1.id = t2.id )

比对两个库数据语句

select t1.sb_com_num,t2.sb_com_num from sb_base t1,sb_base_linshi t2 where t1.sb_id =t2.sb_id and t1.sb_com_num<>t2.sb_com_num