Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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