CEIL « Numeric Math Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Numeric Math Functions
  3. CEIL
1.CEIL(x): Returns the smallest integer greater than or equal to x
2.CEIL: Returns the ceiling value (next highest integer above a number)
3.CEIL(-5.2)
4.CEILING() and FLOOR()
5.select ceil( 10.00000000001 ) from dual
6. select ceil( -1.99 )from dual;