I copy and paste simple sql statement without the =3D3D but somehow it = was added when posted ...here is the statement again (hopefully without extra syntax): update tab1 set tab1.col1 =3D tab1.col1 + summ.col1,tab1.col3 =3D case when = tab1.col3 =3D 'A' and (tab1.col1 + summ.col1) >=3D tab1.col5 then 'C' else tab1.col3 = end from tab1 inner join tab2 summ on tab1.col3 =3D summ.col3 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Gogala, Mladen Sent: Monday, August 16, 2004 1:55 PM To: 'oracle-l@xxxxxxxxxxxxx' Subject: RE: Update statement question You could try without the "=3D3D" part. It doesn't serve any=20 discernible purpose. -- Mladen Gogala Oracle DBA email:mladeng@xxxxxxxxx Ext: 9787 > -----Original Message----- > From: Harvinder Singh [mailto:Harvinder.Singh@xxxxxxxxxxxxx]=20 > Sent: Monday, August 16, 2004 1:47 PM > To: oracle-l@xxxxxxxxxxxxx > Subject: Update statement question > on tab1.col3 =3D3D summ.col3 >=20 > How can I rewrite this in oracle? >=20 > Thanks > --Harvinder ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------