CEIL(-5.2) : CEIL « Numerical Math Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Numerical Math Functions
  3. CEIL
SQL> select CEIL(-5.2) from dual;

CEIL(-5.2)
----------
        -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)