CEIL function

CEIL returns smallest integer greater than or equal to n.

Ceil (n)

Where n is a number.

This function takes as an argument any numeric datatype or any nonnumeric datatype that can be implicitly converted to a numeric datatype. The function returns the same datatype as the numeric datatype of the argument.

select CEIL(10.40) from dual;

select CEIL(10.50) from dual;

select CEIL(10.60) from dual;