data issue

hello all

due to various issues the application code entred data into a wrong column

for example two tables


customer data
------------------
cdataid number(15) --- primary key
customerinfoid number(10)
customerid number(10).

we inserted customerinfoid data into customerid column and vice-versa.

Is there a easy way to change this???


Pls let me know

Thanks

Code:

---

UPDATE customer_data
SET customerinfoid = customerid,
    customerid = customerinfoid;

---

thanks

You could just rename the columns too. Obviously, it'll affect your dependant objects though.