Oracle
Oracle查询平时使用plsql不会遇到的round(1/2)=0.5的小数点前不带0及cast()后带0问题。整合mybatis遇到数值显示问题,在sql语句可解决。
num = 1/2(是一个变量,此变量大于0或小于0时 第3或4种方法都适用 )
- round(num,2) = .5
- cast(round(num,2) as number(10,2))= .50
- decode(substr(round(num,2) ,1,1),’.’,‘0’||round(num,2),round(num,2))= 0.5
- decode(substr(cast(round(num,2) as number(10,2)),1,1),’.’,‘0’||cast(round(num,2) as number(10,2)),cast(round(num,2) as number(10,2)))= 0.50