CEIL

The CEIL function returns the smallest whole number greater than or equal to a specified number.

Return Value

NUMBER

Syntax

CEIL(n)

Arguments

n: A whole number (NUMBER datatype) that you specify.

Examples

Example 8-43 Displaying the Smallest Integer Greater Than or Equal to a Number

The following statements show results returned by CEIL.

The statement
```
SHOW CEIL(15.7)
```
produces the following result
```
16
```
The statement
```
SHOW CEIL(-6.457)
```
produces the following result.
```
-6
```