如题,在下表A1中,我想按ID字段的顺序,对ID字段重新添加数据成A2表的样子month id
9 5
9 6
9 7
9 8 A1
9 9
9 10
9 11
9 12
month id
9 01
9 02
9 03
9 04
9 05 A2
9 06
9 07
9 08
9 5
9 6
9 7
9 8 A1
9 9
9 10
9 11
9 12
month id
9 01
9 02
9 03
9 04
9 05 A2
9 06
9 07
9 08
9 5
9 6
9 7
9 8 A1
9 9
9 10
9 11
9 12
month id
9 01
9 02
9 03
9 04
9 05 A2
9 06
9 07
9 08
select /*+bypass_ujvc*) a.id, b.rn
from aaaa a, (
select row_number() over (order by id) rn, id from aaaa) b
where a.id = b.id
) set id = rn;
update (
select /*+bypass_ujvc*/) a.id, b.rn from aaaa a, (
select row_number() over (order by id) rn, id from aaaa) b
where a.id = b.id
) set id = lpad(rn, 2, '0');