CEILING() and FLOOR() : CEIL « Numeric Math Functions « Oracle PL / SQL






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

CEILING() and FLOOR()

 

SQL>

Syntax: CEIL(<numeric expression>)     FLOOR(<numeric expression>)

SQL>
SQL> SELECT
  2     CEIL(109.19)  ceil_val,
  3     FLOOR(109.19) floor_val from dual;

  CEIL_VAL  FLOOR_VAL
---------- ----------
       110        109








Related examples in the same category

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.select ceil( 10.00000000001 ) from dual
5. select ceil( -1.99 )from dual;