Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Numerical Math Functions

 

CEIL(x) gets the smallest integer greater than or equal to x

The following example uses CEIL() to display the absolute value of 5.8 and -5.2, respectively: SQL> SELECT CEIL(5.8), CEIL(-5.2) FROM dual;  CEIL(5.8) CEIL(-5.2) ---------- ----------          6         -5