RE: is this possible to do in one sql

From: Guang Mei <gmei_at_incyte.com>
Date: Fri, 17 Dec 2004 13:08:49 -0500
Message-ID: <NJEDKDKJDGAKAEKKNEEJAEKHDOAA.gmei@incyte.com>

Thanks!

Guang

-----Original Message-----

From: Looney, Jason [mailto:Jason.Looney_at_echostar.com] Sent: Friday, December 17, 2004 1:04 PM
To: 'gmei_at_incyte.com'; Oracle-L-freelists Subject: RE: is this possible to do in one sql

--I have both oracle 8i and 9i running. I want to update two columns in a
--table with two different conditions. Is it possible to do it as one sql
--statment?

Sure. Try this:

UPDATE t1 SET
NOTFLAG = DECODE(NOTFLAG, '1', NULL, NOTFLAG), EVIDENCE = DECODE(EVIDENCE, '2', NULL, EVIDENCE) /

Jason.

--

http://www.freelists.org/webpage/oracle-l Received on Fri Dec 17 2004 - 12:10:26 CST