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;