Re: Two columns - exchange

Hi Piotr,

This will produce the correct result

update emp set (name,address) = (select address,name from emp a_emp where a_emp.rowid = dept_test.rowid );

Chris.

sikh wrote in message ...
.... How
>can I exchange the values of two columns named "name" and "address".
Received on Mon Jan 18 1999 - 15:50:40 CST