Abs – Oracle SQL Function

ABS returns the absolute value of a numeric argument.

It takes a numerics value, or any value that can be implicitly converted to a numeric value, as its argument and returns the absolute value as a numeric value.

The return value is the same type as the numeric type of the argument.

Example:

SELECT abs(-255) as absolute_value from dual;

ABSOLUTE_VALUE
——————————
255