Help on Update Query

From: Shankar Muthukrishnan <shankar_at_shore.net>
Date: 1998/01/02
Message-ID: <68islv$nkm@fridge.shore.net>#1/1

I am able to execute the following query on Microsoft SQLServer. The update plugs in 3 column values from T2 into T1. update T1
set T1.col1 = T2.col1,

      T1.col2 = T2.col2,
      T1.col3 = T2.col3

from Table1 T1, Table T2
where (T1.key = T2.key)

Any help on Oracle is appreciated.
Thanks. Received on Fri Jan 02 1998 - 00:00:00 CST