Slight error sorry, should have been the following to allow for
multiple columns.
update twr3_01.orapropertymonthlyderived opmd
set (opmd.m32) =
(
select nvl(opmd.m32, m32)
from twr3_01.orapropertymonthlyderived
where opmd.ipdref = ipdref AND
opmd.periodendmonth = periodendmonth AND
opmd.periodendyear = periodendyear AND
opmd.snapshotref = snapshotref AND
opmd.datastatetypecode = datastatetypecode AND
opmd.sampleref = sampleref AND
opmd.periodendfrequency = periodendfrequency AND
m70 = 1
);
Received on Tue Nov 22 2005 - 11:20:02 CST
