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_at_posting.google.com>
in Ingres I can do this
Date: 1 Jul 2004 02:20:31 -0700
Message-ID: <63b202d.0407010120.61dd8b9f_at_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 - 11:20:31 CEST