就两个字段吗?
update test set starttime = decode(starttime,'2345','9999',starttime),endtime =decode(endtime ,'2345','9999',endtime);
如果想提高速度,加个条件!或者分两句话写!
update test set starttime = decode(starttime,'2345','9999',starttime),endtime =decode(endtime ,'2345','9999',endtime);
如果想提高速度,加个条件!或者分两句话写!
where '2345' in (starttime,endtime);
endtime=case endtime when 2345 then 9999 else endtime end
where starttime=2345 or endtime=2345
create table test1(starttime int,endtime int)
insert into test1 select 1234,2345
union all select 2345,4566
union all select 4566,1245
union all select 1245,1234