CEIL returns the smallest whole number greater than or equal to a specified number.
CEIL
Return Value
NUMBER
Syntax
CEIL(n)
Arguments
n is a numeric expression.
n
Examples
CEIL(3.1415927) returns the value 4.
CEIL(3.1415927)
4
CEIL(-3.4) returns the value -3.00.
CEIL(-3.4)
-3.00
subject
from Anonymous
Comments, corrections, and suggestions are forwarded to authors every week. By submitting, you confirm you agree to the terms and conditions. Use the OTN forums for product questions. For support or consulting, file a service request through My Oracle Support.
Scripting on this page enhances content navigation, but does not change the content in any way.
Quick Lookup
Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages
Main Categories
This Document