CEIL or CEILING Function in Oracle

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;</code>
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 

Result: 0

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

select CEIL(0.5) from dual;<code>
Result: 0

<code>select CEIL(-11.65) from dual;

Result: -11