How to Change Negative Value to Positive in Oracle?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • PLSQL / SQL
  • 1 min read

In Oracle, use ABS function to change negative value to positive value. This function takes as an argument any numeric data type and returns the absolute value.

Syntax

ABS(n)

Oracle ABS Function Examples

1. Using Select Statement

SELECT ABS(-15) Positive_value FROM DUAL;

Output

POSITIVE_VALUE
--------------
15
1 row selected.

2. Using PL/SQL Block

SET SERVEROUTPUT ON;
DECLARE
n_value NUMBER;
BEGIN
n_value := ABS(-9);
DBMS_OUTPUT.PUT_LINE (n_value);
END;
/

Output

9
PL/SQL procedure successfully completed.

See also