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