Posts

Showing posts from September, 2012

oracle update table order by old_id

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