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?