ABS function in Oracle

ABS is one of the vital Numeric/Math functions of Oracle. It is used to get the absolute value of a number. The ABS function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i.
Syntax:

ABS ( number )

Parameters:
number:
It is used to specify the number to get the absolute value of.

Example 1:

ABS (-11)

Output:

11

Explanation:
The absolute value function always returns the positive value of a number and so is the result.

Example 2:

ABS (-11.11)

Output:

11.11

Explanation:
The absolute value function always returns the positive value of a number and so is the result.

Example 3:

ABS (11.11 * -2)

Output:

22.22

Explanation:
The absolute value function always returns the positive value of a number and so is the result.

Please Share