Re: update table a from table b
From: Wit Serdakovskij <wit_at_dba.kiev.ua>
Date: 1 Jul 2004 09:32:33 GMT
Message-ID: <20040701093231.GQ23470_at_tormoz.net>
);
Date: 1 Jul 2004 09:32:33 GMT
Message-ID: <20040701093231.GQ23470_at_tormoz.net>
Hello, michael,
About 02:20 01-Jul from michaelnewport_at_yahoo.com accepted:
> 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 ?
update table1
set field = (
select field from table2 where table2.id = table1.id
);
-- wbr, Wit.Received on Thu Jul 01 2004 - 11:32:33 CEST