due to various issues the application code entred data into a wrong column
for example two tables
cdataid number(15) --- primary key
we inserted customerinfoid data into customerid column and vice-versa.
Is there a easy way to change this???
Pls let me know
SET customerinfoid = customerid,
customerid = customerinfoid;
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
You could just rename the columns too. Obviously, it'll affect your dependant objects though.
Click Here to Expand Forum to Full Width