ORACLE ÖÐ updateʱ decode Óë WHENʹÓÃ

update 
PRICE_INFO_TBL set 
USER = decode(PRICE,PRICE != 0,1,9)


ÎÒÏë¸üÐÂPRICE_INFO_TBL ±í£¬µ±PRICE ²»Îª0 µÄʱºò USER ×Ö¶ÎΪ1 ·ñÔò USER ×Ö¶ÎΪ9
updateʱ decode Õ¦Óð¡
ÏñÎÒÉÏÃæÄÇôÓò»ÐÐ ºÇºÇ ¶ªÈËÁË
Ï£Íû´óϺ¸øÖ¸µã£¡Ð»Ð»£¡

---

SQL code:
update
PRICE_INFO_TBL set
USER = (case when PRICE <> 0 then 1 else 9 end)

---

ÒýÓÃ

SQL code
update
PRICE_INFO_TBL set
USER = (case when PRICE <> 0 then 1 else 9 end)

¶¥Ò»¸ö£¡

---

SQL code:
UPDATE PRICE_INFO_TBL SET USER = decode(PRICE, 0, 9, 1);

---

лл¸÷λ