| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Update statement question
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Gogala, Mladen
Sent: Monday, August 16, 2004 1:55 PM
To: 'oracle-l_at_freelists.org'
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_at_aetvn.com Ext: 9787Received on Mon Aug 16 2004 - 12:58:12 CDT
> -----Original Message-----
> From: Harvinder Singh [mailto:Harvinder.Singh_at_MetraTech.com]=20
> Sent: Monday, August 16, 2004 1:47 PM
> To: oracle-l_at_freelists.org
> 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_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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------
 |
 |