Showing posts with label ABS. Show all posts
Showing posts with label ABS. Show all posts

Saturday, September 15, 2012

ABS Function

This was run on Oracle 11.1.0.6.0 on Windows XP. The ABS function returns the absolute value of a column or value:

SQL> select abs(4.3) from dual;

  ABS(4.3)
----------
       4.3

SQL> select abs(-2.9) from dual;

 ABS(-2.9)
----------
       2.9

SQL>