CEIL(x) gets the smallest integer greater than or equal to x. : CEIL « Numerical Math Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Numerical Math Functions
  3. CEIL

The following example uses CEIL() to display the absolute value of 5.8 and -5.2, respectively:

SQL> SELECT CEIL(5.8), CEIL(-5.2) FROM dual;

 CEIL(5.8) CEIL(-5.2)
---------- ----------
         6         -5








14.8.CEIL
14.8.1.CEIL(x) gets the smallest integer greater than or equal to x.
14.8.2.Use CEIL function to get the ceiling value
14.8.3.CEIL for negative value
14.8.4.CEIL(5.8)
14.8.5.CEIL(-5.2)