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;
 

服务器租用/服务器托管中国五强！虚拟主机域名注册顶级提供商！15年品质保障！--亿恩科技[ENKJ.COM]