CEIL function in Oracle

The CEIL functions round the specified number up, and return the smallest number that is greater than or equal to the specified number.

Syntax is:-

CEIL (NUMBER);

Example is:-

SELECT CEILING(1);
--> 1

SELECT CEIL(10.23) CEIL_FUNCTION FROM DUAL;
--> 11

SELECT CEIL(99.1) CEIL_FUNCTION FROM DUAL;
--> 100

SELECT CEIL(99) CEIL_FUNCTION FROM DUAL;
--> 99

SELECT CEIL(-99.1) CEIL_FUNCTION FROM DUAL;
--> -99

Read Also:-  CEIL function in Greenplum