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

Home -> Community -> Usenet -> comp.databases.oracle -> update table a from table b

update table a from table b

From: michael newport <michaelnewport_at_yahoo.com>
Date: 1 Jul 2004 02:20:31 -0700
Message-ID: <63b202d.0407010120.61dd8b9f@posting.google.com>


in Ingres I can do this

update table1 from table2
set table1.field = table2.field
where table1.id = table2.id

is there an equivalent in Oracle ?

Regards
Michael Newport Received on Thu Jul 01 2004 - 04:20:31 CDT

Original text of this message

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