thanks, but how would this be done for the same table?
update table1 t1 set (c2, c3 ) =
( select c2, c3 from table1 t2 where t1.c1 = t2.c1 and t1.oid < t2.oid
);
and, when tables are listed in the from clause, are they comma
separated?
__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com