Oracle CEIL function.

Preamble

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

Oracle/PLSQL syntax of CEIL function

CEIL( number_id )

Parameters and function arguments

• number-id – this value is used to search for the smallest integer number.

The CEIL function returns the integer value.

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

Let’s consider some examples of the CEIL function and learn how to use the CEIL function in Oracle/PLSQL.

SQL> SELECT CEIL(32.65) FROM DUAL;

-result: 33

SQL> SELECT CEIL(32.1) FROM DUAL;

-result: 33

SQL> SELECT CEIL(32) FROM DUAL;

-result: 32

SQL> SELECT CEIL(-32.65) FROM DUAL;

-result: -32

SQL> SELECT CEIL(-32) FROM DUAL;

-result: -32

About Enteros

​​​Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.​