In Oracle/PLSQL, the ceil function returns the smallest integer value that is greater than or equal to a number.
Syntax
The syntax for the ceil function is:
ceil( number )
number is the value used to find the smallest integer value.
Applies To
- Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i
For Example
| ceil(32.65) | would return 33 |
| ceil(32) | would return 32 |
| ceil(-32.65) | would return -32 |
| ceil(-32) | would return -32 |
