ceil function
Ceil returns next highest integer value regardless of the fraction.
The next highest refers to the actual higher number whether positive or negative.
SQL> select ceil(1.1) from dual;
CEIL(1.1)
----------
2
SQL> select ceil(1.9) from dual;
CEIL(1.9)
----------
2
SQL> select ceil(-1.1) from dual;
CEIL(-1.1)
----------
-1
SQL> select ceil(-1.9) from dual;
CEIL(-1.9)
----------
-1
SQL> select ceil(0) from dual;
CEIL(0)
----------
0
SQL>