CEIL |
CEIL(n) |
Returns the lowest valued integer that is greater than or equal to the input. If n is already an integer, n will be returned.
Example
SQL> SELECT CEIL(10), CEIL(10.5), CEIL(-10.5) 2 FROM dual; CEIL(10) CEIL(10.5) CEIL(-10.5) ---------- ---------- ----------- 10 11 -10
Notice that for negative numbers, the sign is relevant: -10 is greater than -10.5.
Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.