ORACLE关联表批量更新,该怎么解决
ORACLE关联表批量更新
表A为主表,
表B为excel导入的临时表,
现在想将表B上的数据更新到表A中,请问如何更新呀
关联为,asses_number
要更新的字段为user_id
------解决方案--------------------
------解决方案--------------------
表A为主表,
表B为excel导入的临时表,
现在想将表B上的数据更新到表A中,请问如何更新呀
关联为,asses_number
要更新的字段为user_id
------解决方案--------------------
MERGE INTO A
USING B
ON (a.asses_number = b.asses_number)
WHEN MATCHED THEN UPDATE set a.user_id = b.user_id
------解决方案--------------------
MERGE INTO A a
USING B b
ON (a.asses_number = b.asses_number)
WHEN MATCHED THEN UPDATE set a.user_id = b.user_id
WHEN NOT MATHED THEN INSERT (a.user_id) values(b.user_id);