Oracle: Updating a table column using ROWNUM in conjunction with ORDER BY clause
This should work (works for me) update table_a outer set sequence_column = ( select rnum from ( — evaluate row_number() for all rows ordered by your columns — BEFORE updating those values into table_a select id, row_number() over (order by column1, column2) rnum from table_a) inner — join on the primary key to be sure … Read more