ORACLE SEQUENCE COLUMN BASED ON ORDER BY OF OTHER COLUMN

Ref: http://forums.oracle.com/forums/thread.jspa?threadID=1026326



I have a table which is having lots of rows . I wish to update column (recno) with a sequential number from 1 to 75,000 order by mycolumn.