读书人

oracle的update连表更新施用内联视图

发布时间: 2012-09-03 09:48:39 作者: rapoo

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;

读书人网 >PowerDesigner

热点推荐