I think you can just type in
update yourtable set name=address, address=name;
I believe it works.
Project Account(Dr. D. Cheung and pshek) wrote in message
<78kanh$ekb$1_at_www.csis.hku.hk>...
>sikh (sikh_at_friko5.onet.pl) wrote:
>: Hello !
>
>: I am learning Oracle and SQL - (english too :)) and I have a problem. How
>: can I exchange the values of two columns named "name" and "address". Both
>: are varchar2(200) and both are existing in the same table "emp".
>: Help, please ;)
>
> How about renaming the columns... ? (don't know if there's any
>impact on the indexes...)
>
>
>
Received on Tue Jan 26 1999 - 16:31:25 CST
