CEIL(x): Returns the smallest integer greater than or equal to x : CEIL « Numeric Math Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Numeric Math Functions
  3. CEIL

CEIL(x): Returns the smallest integer greater than or equal to x


SQL> --CEIL(x): Returns the smallest integer greater than or equal to x.
SQL>
SQL> select CEIL(5.8) from dual;

 CEIL(5.8)
----------
         6

SQL>








Related examples in the same category

1.CEIL: Returns the ceiling value (next highest integer above a number)
2.CEIL(-5.2)
3.CEILING() and FLOOR()
4.select ceil( 10.00000000001 ) from dual
5. select ceil( -1.99 )from dual;