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