RE: is this possible to do in one sql
- From: "Looney, Jason" <Jason.Looney@xxxxxxxxxxxx>
- To: "'gmei@xxxxxxxxxx'" <gmei@xxxxxxxxxx>, Oracle-L-freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 17 Dec 2004 11:04:22 -0700
--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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
