Oracle ceil rounded up and ceil rounded up

Oracle ceil rounded up and ceil rounded up
Select ceil (3.05/0.5), 3.05/0.5 from dual;

Ceil (3.05/0.5) = 7
3.05/0.5 = 6.1
Ceil (3.55/0.5) = 8
3.55/0.5 = 7.1
Oracle integer Functions

Ceil (x) rounded up
Floor (x) rounded down
Round (x, n) is an integer when n = 0.

X is your decimal number.

Oracle integer Functions

Oracle integer functions include the following:

1. INTEGER (large)
Select ceil (-1.001) value from dual

2. Round (small)
Select floor (-1.001) value from dual

3. Round (truncation)
Select trunc (-1.002) value from dual

4. Round (rounding)
Select round (-1.001) value from dual