CEIL

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

Return Value

NUMBER

Syntax

CEIL(n)

Parameters

n: A number (NUMBER data type) that you specify.

Examples

OLADM1538 Example 7-38 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
```

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

This Document

New and changed documents: