CEIL

Syntax

Purpose

CEIL returns smallest integer greater than or equal to n.

Example

SELECT CEIL(15.7) "Ceiling" FROM DUAL;

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