1.取整(大) select ceil(1.5) from dual
2.取整(小) select floor(1.5) from dual
3.取整(截取) select trunc(1.5) from dual
4.取整(舍入) select round(1.5) from dual
2.Oracle取整 2010-07-21
最新推荐文章于 2023-08-11 11:24:33 发布
1.取整(大) select ceil(1.5) from dual
2.取整(小) select floor(1.5) from dual
3.取整(截取) select trunc(1.5) from dual
4.取整(舍入) select round(1.5) from dual