The ABS() function returns the absolute value of a numeric input argument.
SQL> ABS() Syntax: ABS(<numeric expression>) SQL> SQL> SELECT 2 ABS(-100) negative, 3 ABS(100) positive from dual; NEGATIVE POSITIVE ---------- ---------- 100 100