Skip to Main Content

Oracle Database Discussions

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 values in DB

451784Mar 7 2007 — edited Mar 7 2007
Hi all,
i ahve a column in my database which will going to store the negative numbers like -2, -3 etc as well positive number.
May i know which datatype to use.
I have currently used Number(2) as no value is > 99
but unfortunately when i tried to load a file which contains the values like -3 ,
it gives error.

Kindly help

Regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 4 2007
Added on Mar 7 2007
5 comments
3,440 views