Purpose
You can call this function to return the smallest integer that is greater than or equal to the value of numeric_expression.
Syntax
CEIL (numeric_expression)
Parameters
| Parameter | Description |
|---|---|
| numeric_expression | An expression of an exact or approximate numeric data type, such as NUMBER, FLOAT, BINARY_FLOAT, or BINARY_DOUBLE. |
Return type
The return type is the same as the data type of numeric_expression.
Examples
The following example returns the smallest integers that are respectively greater than or equal to -1.5, 1.5, 2, and 6-9.5.
obclient> SELECT CEIL(-1.5),CEIL(1.5),CEIL(2),CEIL(6-9.5) FROM DUAL;
+------------+-----------+---------+-------------+
CEIL(-1.5) CEIL(1.5) CEIL(2) CEIL(6-9.5)
+------------+-----------+---------+-------------+
-1 2 2 -3
+------------+-----------+---------+-------------+
1 row in set