Tuesday, September 4, 2012

oracle update table order by old_id

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

No comments:

Post a Comment