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> --