swapping a two rows in one update statement?

[grajeshkumar82]

how to update two rows of one particular column in one update statement
for example emp_id 102 name is sam and emp_id 103 name is raj how to interchange or update or swap empid 102 name as raj empid 103 as sam?
pls reply me but dont answer its possible in plsql like that?
in one update statement how to swap?

[davey23uk]

its possible in plsql

[citldba]

I don't see how you could do this in one sql statement, because as soon as you update the first row you've lost the value you need for the second update. Hence why you need plsql

[grajeshkumar82]

without commiting how can i lost first row value also there is not possible of row locking,
i thing its possible in sql statement, without using plsql?

[citldba]

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

Tell us how then !

[gopu_g]

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

Possible, then do it

[PAVB]

SQL> 
SQL> create  table boring_test
  2  (emp_id number,
  3   name   varchar2(20))
  4  ;

Table created.

SQL> insert into boring_test values(102, 'sam');

1 row created.

SQL> insert into boring_test values(103, 'raj');

1 row created.

SQL> commit;

Commit complete.

SQL> select  *
  2  from    boring_test;

    EMP_ID NAME
---------- --------------------
       102 sam
       103 raj

SQL> 
SQL> update  boring_test
  2  set     name = decode(name, 'sam','raj','raj','sam',name)
  3  ;

2 rows updated.

SQL> commit;

Commit complete.

SQL> select  *
  2  from    boring_test;

    EMP_ID NAME
---------- --------------------
       102 raj
       103 sam

SQL>