The Oracle and PL/SQL CEIL function returns the smallest integer value that is greater than or equal to a number (n).
CEIL(n)
Example 1:
SELECT CEIL(45.1242) FROM DUAL;
46
Example 2:
SELECT CEIL(-45.1242) FROM DUAL;
45
The Oracle and PL/SQL CEIL function returns the smallest integer value that is greater than or equal to a number (n).
CEIL(n)
Example 1:
SELECT CEIL(45.1242) FROM DUAL;
46
Example 2:
SELECT CEIL(-45.1242) FROM DUAL;
45