Oracle PL/SQL Programming, Third Edition

Name

CEIL

Synopsis

The CEIL (“ceiling”) function returns the smallest integer greater than or equal to the specified number. The specification for the CEIL function is:

FUNCTION CEIL (n NUMBER) RETURN NUMBER;

Here are some examples of the effect of CEIL:

CEIL (6) --> 6
CEIL (119.1) --> 120
CEIL (-17.2) --> -17

For a comparison of CEIL with several other numeric functions, see Table 9-7 and Figure 9-5 earlier in Section 9.3.1.