oracle update table order by old_id

update (select * from mytable order by old_id) set new_id = mysequence.nextval;

Comments

Popular posts from this blog

Project euler 169 found clue

Floyd-Warshall's algorithm