关于Oracle取整的函数分别有以下几种:
1.取整(大)
select ceil(-1.001) value from dual
2.取整(小)
select floor(-1.001) value from dual
3.取整(截取)
select trunc(-1.002) value from dual
4.取整(舍入)
select round(-1.001) value from dual
1.取整(大)
select ceil(-1.001) value from dual
2.取整(小)
select floor(-1.001) value from dual
3.取整(截取)
select trunc(-1.002) value from dual
4.取整(舍入)
select round(-1.001) value from dual