Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Negative numbers returned as positive

284951May 31 2002

I am using ADO to connect to an Oracle 8.1.7 Release 3 database. There is a table that has a number field and some rows have negative numbers. If I try to execute the folowing statement:

select numberField
from testTable;

And I have, say 2 rows with -5 and -2, what is actually returned is 5 and 2.
Where is the minus signal?

Please help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 2 2002
Added on May 31 2002
3 comments
770 views