Returns the lowest valued integer that is greater than or equal to the input. If n is already an integer, n will be returned.


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.