How to use the Oracle function for rounding up?

2 years ago

Jackson Davis

1 minute

In Oracle, you can use the CEIL function to round up numbers. The syntax for this function is as follows:

CEIL(number)

The number needs to be rounded up.

For example, if you want to round up a decimal number, you can use the following SQL statement:

SELECT CEIL(3.14) FROM dual;

This will return the result 4, which is the value of rounding up 3.14.