本文介绍了一种使用Oracle数据库实现从一张表（gsis_cul_kkxxk）向另一张表（gsis_cul_pyfap）批量更新数据的方法。通过SELECT...UPDATE语句结合表连接，可以有效地同步两表间对应字段的数据。
oracle,根据一张表数据（table）批量更新另一张表的数据。
update (SELECT /*+BYPASS_UJVC*/
k.XYH as A1,
k.NJ as A2,
k.YJXK as A3,
k.EJXK as A4,
k.ZSJJ as A5,
k.SYLB as A6,
k.BBD as A7,
k.XLJY as A8,
k.SSXWLX as A9,
k.PYCC as A10,
k.XZ as A11,
p.XYH as B1,
p.NJ as B2,
p.YJXK as B3,
p.EJXK as B4,
p.ZSJJ as B5,
p.SYLB as B6,
p.BBD as B7,
p.XLJY as B8,
p.SSXWLX as B9,
p.PYCC as B10,
p.XZ as B11
FROM gsis_cul_kkxx k , gsis_cul_pyfa p
WHERE k.pyfabh = p.resource_id
and k.pyfakcbh is not null
and k.pyfabh is not null )
set A1 = B1,
A2 = B2,
A3 = B3,
A4 = B4,
A5 = B5,
A6 = B6,
A7 = B7,
A8 = B8,
A9 = B9,
A10 = B10,
A11 = B11update (SELECT /*+BYPASS_UJVC*/
k.XYH as A1,
k.NJ as A2,
k.YJXK as A3,
k.EJXK as A4,
k.ZSJJ as A5,
k.SYLB as A6,
k.BBD as A7,
k.XLJY as A8,
k.SSXWLX as A9,
k.PYCC as A10,
k.XZ as A11,
p.XYH as B1,
p.NJ as B2,
p.YJXK as B3,
p.EJXK as B4,
p.ZSJJ as B5,
p.SYLB as B6,
p.BBD as B7,
p.XLJY as B8,
p.SSXWLX as B9,
p.PYCC as B10,
p.XZ as B11
FROM gsis_cul_kkxx k , gsis_cul_pyfa p
WHERE k.pyfabh = p.resource_id
and k.pyfakcbh is not null
and k.pyfabh is not null )
set A1 = B1,
A2 = B2,
A3 = B3,
A4 = B4,
A5 = B5,
A6 = B6,
A7 = B7,
A8 = B8,
A9 = B9,
A10 = B10,
A11 = B11
转载于:https://blog.51cto.com/q1ngp2ng/1406671
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
