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:02:36 CST