oracle的update连表更新施用内联视图
oracle的update连表更新使用内联视图
oracle的update连表更新使用内联视图:
UPDATE (SELECT /*+ BYPASS_UJVC */a.Brchcd AS a_Brchcd,
b.Usedbr AS b_Usedbr
FROM Com_Brch a,
Asd_Card6 b
WHERE Substr(b.Usedbr,
-4) = Substr(a.Brchna,
-4))
SET b_Usedbr = a_Brchcd;