Skip to content
Home / Database / ABS function in Oracle SQL

ABS function in Oracle SQL

ABS function in Oracle SQL returns the absolute value. Let’s assume a number -10 when you run the abs function of this number it returns 10 which is an absolute value. This function also works on the decimal.

Syntax

ABS(N)

N – input parameter

SELECT ABS(-10)FROM DUAL;

  Absolute
----------
        10