HomePrivacy PolicyFeedbackLink to usSite Map

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.