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 O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.