swapping a two rows in one update statement?

[gopu_g]

i thing its possible in sql statement, without using plsql?

Possible, then do it