Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> is this possible to do in one sql

is this possible to do in one sql

From: Guang Mei <gmei_at_incyte.com>
Date: Fri, 17 Dec 2004 13:00:33 -0500
Message-ID: <NJEDKDKJDGAKAEKKNEEJGEKGDOAA.gmei@incyte.com>


Hi,

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?

For example,

create table t1 (NOTFLAG CHAR(1), EVIDENCE CHAR(1));

insert into t1 (NOTFLAG,EVIDENCE ) values ('1','1'); insert into t1 (NOTFLAG,EVIDENCE ) values ('2','2'); commit;

select * from t1;

Thanks,

Guang

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 17 2004 - 11:55:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US