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

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 4 2007

Added on Mar 7 2007

#general-database-discussions

5 comments

3,440 views