现在我想将表B合并到A,这意味着我想将表A中的field_2更新为表B的值.那么如何实现呢?顺便说一下,我正在使用oracle
谢谢
MERGE INTO table_b USING ( SELECT id,field_2 FROM table_a ) ta ON (ta.id = table_b.id) WHEN MATCHED THEN UPDATE SET table_b.field_2 = ta.field_2