SQL: Structured Query Language - Oracle 10g Database Administration Concepts and Implementation Made Simple - page 31

Example:
SELECT CEIL(25.7) "Result"
FROM DUAL;
Output:
Result
----------
26
Example:
SELECT FLOOR(25.7) "Result"
FROM DUAL;
Output:
Result
----------
25
Example:
SELECT ROUND(25.29,1) "Round"
FROM DUAL;
Output:
Round
----------
25.3
SELECT ROUND(25.29,-1) "Round"
FROM DUAL;