Ad:

Oracle Discussion Thread
Unsolved
Views: 2224

Nov 13th, 2008

Subtracting a negative value

Expand Post »

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.)

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?

Similar Threads

how do i sort reords from Z-A? (in turbo C) in C++
Working with doubles, having some troubles in C++
Need help getting text to display in a graphics window in Python
Java home work help (long post) in Java
Small date problem in ASP

bondo

Reputation Points: 11

Solved Threads: 0

Light Poster

Offline

43 posts
since Apr 2007

Permalink

Nov 13th, 2008

Re: Subtracting a negative value

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

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;

debasisdas

Featured Poster

Reputation Points: 665

Solved Threads: 427

Posting Genius

Offline

6,406 posts
since Feb 2007

Permalink

Nov 13th, 2008

Re: Subtracting a negative value

That was my question. Why am I getting 3?

bondo

Reputation Points: 11

Solved Threads: 0

Light Poster

Offline

43 posts
since Apr 2007

Permalink

Nov 15th, 2008

Re: Subtracting a negative value

the same block of pl/sql code never gives different output to different people on different machine.

debasisdas

Featured Poster

Reputation Points: 665

Solved Threads: 427

Posting Genius

Offline

6,406 posts
since Feb 2007

Permalink

Dec 9th, 2008

Re: Subtracting a negative value

Hai Bondo,
you will never get 3 for the above code..please check it once again...........................

like_to_learn

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

9 posts
since Dec 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Oracle Forum Timeline: Oracle SQL Plus Joining

Next Thread in Oracle Forum Timeline: Deletion of Autonumber

DaniWeb Message

Cancel Changes

User Name
Password