The CEIL or CEILING functions rounds up the given specified number to the smallest number which is greater than or equal to the specified number.

Syntax:

CEIL (number) or CEILING (number)

Return Value: These function returns an integer value.

Example:

FLOATING VALUE returns SMALLEST INTEGER

select CEIL(11.87) from dual;

Result: 12

select CEIL(11.1) from dual;

Result: 12

INTEGER returns INTEGER

select CEIL(12) from dual;

Result: 12

select CEIL(-11) from dual;

Result: -11

NULL returns NULL.

select CEIL() from dual;

Result:

ZERO (0) returns ZERO (0)

select CEIL(0) from dual;

Result: 0

Less than Zero but greater than -1.0 returns Zero(0).

select CEIL(0.5) from dual;

Result: 0

select CEIL(-11.65) from dual;

Result: -11