Update statement question

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Mon, 16 Aug 2004 13:47:10 -0400
Message-ID: <D6424CD4C8A3C044BBC49877ED51C5187D92E3@ex2003.metratech.com>

Hi,

I need to update a table by selecting columns from 2nd table like following logic in SQL Server:

update tab1=20
set tab1.col1 =3D tab1.col1 + summ.col1,=20 tab1.col3 =3D case when tab1.col3 =3D 'A' and (tab1.col1 + summ.col1) =
>=3D

tab1.col5 then 'C' else tab1.col3 end=20 from tab1 inner join tab2 summ
on tab1.col3 =3D summ.col3

How can I rewrite this in oracle?

Thanks
--Harvinder

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Aug 16 2004 - 12:43:01 CDT