- oracle多表关联更新
MERGE INTO a a
USING b b ON (b.code =a.code )
WHEN MATCHED THEN
UPDATE SET a.name =b.name
WHERE b.fid IS NOT NULL;
MERGE INTO a a
USING b b ON (b.code =a.code )
WHEN MATCHED THEN
UPDATE SET a.name =b.name
WHERE b.fid IS NOT NULL;