SQL Abs

Absolute value is the measure of the magnitude of value.

     Absolute value is always a positive number.

     Syntax: abs (value)

     Ex:

          SQL> select abs(5), abs(-5), abs(0), abs(null) from dual;

                     ABS(5)    ABS(-5)     ABS(0)  ABS(NULL)

                     ---------- ----------    ---------- -------------

                          5              -5                0