ABS(x) gets the absolute value of x : ABS « Numerical Math Functions « Oracle PL/SQL Tutorial






The absolute value of a number is that number without any positive or negative sign.

The following example displays the absolute value of 10 and - 10:

SQL> SELECT ABS(10), ABS(-10) FROM dual;

   ABS(10)   ABS(-10)
---------- ----------
        10         10

SQL>








14.2.ABS
14.2.1.ABS(x) gets the absolute value of x
14.2.2.ABS(10)
14.2.3.ABS(-10) (2)
14.2.4.Use ABS for column data
14.2.5.SQRT and ABS