Create a table with id and val columns

select * from test

1 one      

2 two      

3 three    

4 four     

-- Scramble the data with next record value

select a.empno,max(b.val) VAL

from (select * from test) a,

    ...