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;

您可能感兴趣的文章: