Update Joined tables

I have 2 tables

Table1 is customer address table eg
CustID
Addr1
Addr2
TownCity

The other table is
TownCity
TownCityNew

Basically I am wanting to join the 2 TownCity fields, and replace table1 with teh new spelling of TownCity

The reason, is we have 2million customer addresses, and we have some common misspellings, I want to take all of teh common mispellings and replace with correct spelling.

But Oracle doensn't like joins with an update, and PL/SQL cursor takes about 4 hours, MS access can do this in 10 minutes.

Can someone please restore my faith that Oracle is teh best & fastest database in teh world!

Thanks
Dean Received on Wed Dec 26 2001 - 21:15:38 CET