Friday, April 12, 2013

PL / SQL UPDATE + JOIN

1
2
3
4
5
MERGE INTO T1
USING T2
ON (T1.PK = T2.PK)
WHEN MATCHED THEN
UPDATE SET T1.VAL = T2.VAL;