Re this format which I've never come across before:

"UPDATE Product

SET Price = N.Price

FROM Product P JOIN New_Prices N

ON P.ID = N.ID

WHERE P.ProductName = 'Doo-Dads';"

Does anyone know the Oracle equivalent of this? So far, I've always used this format

"UPDATE Product P

SET P.Price = (SELECT N.Price

FROM New_Prices N

WHERE P.ID = N.ID);"

(script not checked for correctness, it's just an example of the structure)

in both Oracle and SQLServer which is OK for one column but a PITA for more than one column as you have to repeat the SELECT for every column.