DBMS/오라클기타

두 테이블간 update

choi121xx 2015. 7. 20. 09:48
   UPDATE TableA
     SET TableA.컬럼A = TableB.컬럼A
    FROM TableB
   WHERE TableA.PK = TableB.PK 
     AND TableA.컬럼A <> TableB.컬럼A 
;