The CEIL function returns the smallest integer that is greater than or equal to the numeric value of numeric_expression.
Syntax
CEIL (numeric_expression)
Parameters
| Parameter | Description |
|---|---|
| numeric_expression | The expression of the exact numeric data types or the approximate numeric data types: NUMBER, FLOAT, BINARY_FLOAT, and BINARY_DOUBLE. |
Return type
The return type is the same as the data type of the numeric_expression parameter.
Examples
This example shows the result of using the CEIL function for three different numbers.
Execute the following statement:
SELECT CEIL(1.2), CEIL(2), CEIL(-12.1) FROM DUAL;
The following query result is returned:
+-----------+---------+-------------+
| CEIL(1.2) | CEIL(2) | CEIL(-12.1) |
+-----------+---------+-------------+
| 2 | 2 | -12 |
+-----------+---------+-------------+