2014. 3. 4. 15:58
Update Subquery Study/Oracle2014. 3. 4. 15:58
UPDATE TABLE1
SET TABLE1.COLUMN1 = (SELECT COL1 FROM TABLE2 WHERE TABLE2.COL2 = TABLE1.COLUMN2 AND TABLE2.COL3 = TABLE1.COLUMN3)
SET TABLE1.COLUMN1 = (SELECT COL1 FROM TABLE2 WHERE TABLE2.COL2 = TABLE1.COLUMN2 AND TABLE2.COL3 = TABLE1.COLUMN3)