Oracle CEIL Function Explained

In Oracle, the CEIL function is used to return the smallest integer that is greater than or equal to the given number. This function rounds up the input number and returns the result.

The grammar is as follows:

CEIL(number)

The number is the value that needs to be rounded.

Here are some examples:

SELECT CEIL(3.2) FROM dual;
-- 输出：4

SELECT CEIL(-5.8) FROM dual;
-- 输出：-5

In the above example, the CEIL function rounds up the numbers 3.2 and -5.8, returning 4 and -5 respectively.