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

codefights smooth sailing ( CommonCharacterCount)

How to remove 8443 port in URL in tomcat