# CEIL function in Oracle

CEIL is one of the vital Numeric/Math functions of Oracle. It is used to get the smallest integer value which is either greater than or equal to the mentioned number. The CEIL function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i.

Syntax:

CEIL( number )


Parameters:
number: It is used to specify the number whose integer value is to be found.

Example 1:

CEIL(-11.11)

Output:

12


Explanation:
Since the number itself is not an integer, thus the smallest integer just greater than 11.11 is 12.

Example 2:

CEIL(11)

Output:

-11


Explanation:
Since the number itself is not an integer, thus the smallest integer just greater than -11.11 is -11.

Example 3:

CEIL(11)

Output:

11


Explanation:
Since the number itself is an integer, thus the result is the number itself.