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