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.


SELECT abs(-255) as absolute_value from dual;


Abs – Oracle SQL Function
Tagged on: