CEIL

Syntax

ceil::=

Text description of ceil

Purpose

CEIL returns smallest integer greater than or equal to n.

Example

The following example returns the smallest integer greater than or equal to 15.7:

SELECT CEIL(15.7) "Ceiling" FROM DUAL;

   Ceiling
----------
        16