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






select ceil( -1.99 )from dual;

 
SQL>
SQL>  select ceil( -1.99 )from dual;
CEIL(-1.99)
-----------
         -1

1 row selected.

SQL>
SQL>
SQL>
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( 10.00000000001 ) from dual