update i_ks_clinical_work set RATE_GOOD_NUM_WORK = round(((CURE_NUM_WORK+GOOD_NUM_WORK)/PATIENTS_NUM_WORK * 10000)/100,2) where PATIENTS_NUM_WORK is not null;
还有可能用到非空判断NVL(CURE_NUM_WORK,0)，NVL(GOOD_NUM_WORK,0)
trunc()不四舍五入，round()四舍五入，%由jsp页面固定
原文链接：https://www.f2er.com/oracle/213142.html