SQL CEIL

This will produce a whole number that is greater than or equal to the specified value.

     Syntax: ceil (value)      

     Ex:

          SQL> select ceil(5), ceil(5.1), ceil(-5), ceil( -5.1), ceil(0), ceil(null) from dual;

                        CEIL(5)  CEIL(5.1)   CEIL(-5) CEIL(-5.1)    CEIL(0) CEIL(NULL)

                          ---------  -----------    ---------- ------------     --------  --------------

                                5            6                -5            -5                 0