swapping a two rows in one update statement?

[citldba]

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

Tell us how then !