SQL> SELECT 666.88,CEIL(666.88),FLOOR(666.88) FROM dual;
666.88 CEIL(666.88) FLOOR(666.88)
---------- ------------ -------------
666.88 667 666
CEIL returns the smallest integer that is greater than or equal to n.
FLOOR returns the largest integer equal to or less than n.