All Products
Search
Document Center

CEIL

Last Updated: Jun 18, 2021

The CEIL function returns the smallest integer that is greater than or equal to the numeric value of numeric_expression.

Syntax

CEIL (numeric_expression)

Parameters

Parameter

Description

numeric_expression

The expression of the exact numeric data types or the approximate numeric data types: NUMBER, FLOAT, BINARY_FLOAT, and BINARY_DOUBLE.

Return type

The return type is the same as the data type of the numeric_expression parameter.

Examples

This example shows the result of using the CEIL function for three different numbers.

Execute the following statement:

SELECT CEIL(1.2), CEIL(2), CEIL(-12.1) FROM DUAL;

The following query result is returned:

+-----------+---------+-------------+
| CEIL(1.2) | CEIL(2) | CEIL(-12.1) |
+-----------+---------+-------------+
|         2 |       2 |         -12 |
+-----------+---------+-------------+