oracleceil取整

2015-07-24 11:02:22 · 作者: · 浏览: 3
select ceil(3.05/0.5),3.05/0.5 from dual;

ceil(3.05/0.5) = 7
3.05/0.5 = 6.1
ceil(3.55/0.5) = 8
3.55/0.5 = 7.1