Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Update on join, how?

Update on join, how?

From: L. Tseng <lesliet_at_u.washington.edu>
Date: 1996/11/07
Message-ID: <55t5eg$54f@nntp1.u.washington.edu>#1/1

Does anyone know how to do an update on join like in Sybase/MS SQL Server?

     update table_A
        set a.cola = 'x'
      FROM  table_A a, table_B b
     where  a.col = b.col
       and .......

It seems to me Oracle does not support the 'FROM' in an update syntax? If yes, why is that? Thanks. Received on Thu Nov 07 1996 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US