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>

No comments: