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