SQL ABS() Function

SQL ABS() function return absolute value of n.

SQL ABS() function take any numeric data type/non numeric data type value that are explicitly convert to numeric data type value and finally value return same data type at the time of function taken argument.

Supported Oracle SQL Version

  • Oracle 8i
  • Oracle 9i
  • Oracle 10g
  • Oracle 11g
  • Oracle 12c
  • Oracle 18c

Example

following example return absolute value of the -15 value,

SQL> SELECT ABS(-15) FROM DUAL;

  ABS(-15)
----------
        15