Oracle ABS function.

Preamble

The Oracle/PLSQL ABS function returns the absolute value of a number.

Oracle/PLSQL syntax of the ABS function

ABS( number_id )

Parameters and function arguments

• number_id – for conversion to absolute value.

The ABS function returns a numeric value.

ABS function in the following versions of Oracle/PLSQL

Let’s look at some examples of the ABS function to understand how to use the ABS function in Oracle/PLSQL.

SELECT ABS(-23) FROM DUAL;

--Result: 23

SELECT ABS(-23.6) FROM DUAL;

--Result: 23.6

SELECT ABS(-23.65) FROM DUAL;

--Result: 23.65

SELECT ABS(23.65) FROM DUAL;

--Result: 23.65

SELECT ABS(23.65 * -1) FROM DUAL;

--Result: 23.65

About Enteros

​​​Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.​