RE: Update statement question
- From: "Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 16 Aug 2004 14:02:32 -0400
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
-----------------------------------------------------------------
Other related posts:
