select floor(1.23) from dual;
result : 1
select ceil(1.23) from dual;
result : 2
select trunc(1.56) from dual;
result : 1
select round(1.56),round(1.4) from dual;
result : 2,1
select floor(1.23) from dual;
result : 1
select ceil(1.23) from dual;
result : 2
select trunc(1.56) from dual;
result : 1
select round(1.56),round(1.4) from dual;
result : 2,1