ÇóÒ»¾ä¾­µäoracle update¸üÐÂÓï¾ä

id  fund1  fund2 
1    0.00  234
2    123    0.00


ÈçÉÏ±í£¬ÎÒÏë¸üРÈç¹û fund1µÄֵΪ0.00ÄÇô¸üÐÂfund2.·´Ö®¸üÐÂfund1

ÎÒдµÄÓï¾äÈçÏ£¬²»ÄÜÖ´ÐÐ
update table a set  decode('0.00',fund2,'fund1','fund2 '  )  = '250' where id ='1'

¼òµ¥µã˵¾ÍÊÇ  if  fund1>0 Ö´ÐÐ
update table a set  fund1= '250' where id ='1';
if  fund2>0 Ö´ÐÐ
update table a set  fund2= '250' where id ='1';

ÓÃÒ»¾äÓï¾äÔõôд

лл£¡£¡

---

update table a set  decode(fund2,'0.00','fund1','fund2 '  )  = '250' where id ='1'
ÊÔÊÔ

---

id  fund1  fund2 
1    0.00  234
2    123    0.00

SQL code:

update tab1 set fund1=(case when fund2>0 then 250 else fund1 end),
fund2=(case when fund1>0 then 250 else fund2 end)
where id='1'

---

update t set fund1 = (case when fund1 > 0 then 250 else fund1 end),
            fund2 = (case when fund2 > 0 then 250 else fund2 end)
where id = 1;

---

update table a set