select ceil( 10.00000000001 ) from dual : CEIL « Numeric Math Functions « Oracle PL / SQL






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

select ceil( 10.00000000001 ) from dual

 
SQL>
SQL>
SQL> select ceil( 10.00000000001 )  from dual;
CEIL(10.00000000001)
--------------------
                  11

1 row selected.

SQL> --








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