UPDATE with Oracle ??? with join ???

With SQl server or Ingres you can excute this kind of query :

update table1 from table2
set table1.col2 = table2.col2 where
table1.col1 = table2.col1

or

update table1
set table1.col2 = table2.col2
from table2
 where table1.col1 = table2.col1

[Quoted] can we do this kind of update with a join using Oracle (9i) ?? Please help me by giving me an exemple that works !!!

Thanks Received on Wed Nov 19 2003 - 19:34:32 CET