测试一下, 代码如下:
merge into table2 a
using
(
select t2.rowid rid,
t1.x_order_id,
t1.name,
t1.address
from (select row_number() over(partition by subcase_id order by rowid) rn,
table1.*
from table1) t1,
(select row_number() over(partition by subcase_id order by rowid) rn,
table2.*
from table2)t2
wheret1.subcase_id = t2.subcase_id
and t1.rn = t2.rn
) b
on(a.rowid = b.rid)
when matched then
update set a.x_order_id = b.x_order_id,
a.name = b.name,
a.address = b.address;
|