Oracle CEIL() function
Description
The CEIL() function returns the smallest integer that is not less than the number specified as an argument.
The function takes any numeric or nonnumeric data type (can be implicitly converted to a numeric data type) as an argument.
Syntax:
CEIL(N);
Parameters:
Name | Description |
---|---|
N | A number. |
The function returns the same data type as the numeric data type of the argument.
Pictorial Presentation of CEIL() function

Example:
The statement below returns 1562 which is the smallest integer value not less than the value specified (1561.75) in the argument.
SELECT 1561.75 AS "Number", CEIL(1561.75)
FROM dual;
Here is the result
Number CEIL(1561.75) ---------- ------------- 1561.75 1562
Example: CEIL() function with negative value
The statement below returns -1561 which is the smallest integer value not less than the value specified (-1561.75) in the argument.
SELECT -1561.75 AS "Number", CEIL(-1561.75)
FROM dual;
Here is the result
Number CEIL(-1561.75) ---------- -------------- -1561.75 -1561
- Weekly Trends
- Python Interview Questions and Answers: Comprehensive Guide
- Scala Exercises, Practice, Solution
- Kotlin Exercises practice with solution
- MongoDB Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - JOINS
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- JavaScript String Exercises
- JavaScript HTML Form Validation
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join
We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook