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.