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 = 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');
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');