Oracle

Subtracting a negative value

Please support our Oracle advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Apr 2007

Posts: 37

Reputation: bondo is an unknown quantity at this point

Solved Threads: 0

bondo

Offline

Light Poster

Subtracting a negative value

Nov 13th, 2008

Does anyone know how Oracle's PL/SQL handles subtraction with a negative number? Really what I need to know is, given the following: (NOTE: this is NOT the code I'm working with. It's just an example to give and idea of what I'm trying to do.)

 Help with Code Tags 
 Oracle Syntax (Toggle Plain Text) 
DECLARE
number1 NUMBER;
number2 NUMBER;
number3 NUMBER;
BEGIN
number1 := 5;
number2 := -2;
number3 := number1 - number2;
END;
/
DECLARE
number1 NUMBER;
number2 NUMBER;
number3 NUMBER;
BEGIN
number1 := 5;
number2 := -2;
number3 := number1 - number2;
END;
/

How do I get number3 to be 7, like math is supposed to work (5 - (-2) = 7)? I keep getting 3. Anyone?

•

Join Date: Feb 2007

Posts: 2,068

Reputation: debasisdas will become famous soon enough

Solved Threads: 123

debasisdas debasisdas is offline

Offline

Postaholic

Re: Subtracting a negative value

Nov 13th, 2008

but i am getting 7, how come you are getting 3 ?

 Help with Code Tags 
 oracle Syntax (Toggle Plain Text) 
DECLARE
number1 NUMBER;
number2 NUMBER;
number3 NUMBER;
BEGIN
number1 := 5;
number2 := -2;
number3 := number1 - number2;
dbms_output.put_line(number3);
END;
DECLARE
number1 NUMBER;
number2 NUMBER;
number3 NUMBER;
BEGIN
number1 := 5;
number2 := -2;
number3 := number1 - number2;
dbms_output.put_line(number3);
END;