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.
