Oracle / PLSQL: CEIL Function

This article is written about how to use the Oracle/PLSQL CEIL function with syntax and examples.

Description

The Oracle/PLSQL CEIL function returns the smallest integer value that is greater than or equal to a number.

Syntax

The syntax for the CEIL function in Oracle/PLSQL is:

CEIL( number )

Parameters or Arguments

number

The value used to find the smallest integer value.

Returns

The CEIL function returns an integer value.

Applies To

The CEIL function can be used in the following versions of Oracle/PLSQL:

Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i

Example

Let’s look at some Oracle CEIL function examples and explore how to use the CEIL function in Oracle/PLSQL.

For example:

CEIL(32.65)
Result: 33

CEIL(32.1)
Result: 33

CEIL(32)
Result: 32

CEIL(-32.65)
Result: -32

CEIL(-32)
Result: -32