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!

Adding negative numbers accross columns

504701Mar 9 2009 — edited Mar 9 2009

Hey Guys/Gals,

Pretty lame question eh? I know but it has stumped me.

My application is writing cost based numbers to the database table eg: -31.89, the table column datatype is Varchar2.

I can convert the varchars TO_NUMBER but it is not doing the addition. Does oracle have something against adding negative numbers?

Thanks
Rob

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 6 2009

Added on Mar 9 2009

5 comments

2,063 views