Question

oracle如何批量update

根据两个字段更新一个表，字段A，字段B。如果只根据字段A更新表的话。
update table set ....where A in (....)
如果根据字段A和字段B更新呢？ A B是一一对应的。

Answer 1

UPDATE
TAB_1 t1
SET
(
t1.f1
,t1.f2
) =
(SELECT
t2.f1
,t2.f2
FROM TAB_2 t2
WHERE t1.f1 = t2.f2
AND t1.f2 = t2.f2
AND t1.f3 = t2.f3
)
WHERE EXISTS (SELECT 1
FROM TSRCREW.WK_UBH0200Z t2
WHERE t1.f1 = t2.f1
AND t1.f2 = t2.f2
AND t1.f3 = t2.f3);

Answer 2

update table set (a,b) = (select c,d from dual) where .....

Answer 3

update table set (x,y)=(select a,b from where )

Answer 4

写脚本