Skip to Main Content
Forums

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!

Number is rounded up on insert

Michael ShapiraApr 16 2015 — edited Apr 16 2015

Hi. I have a data 1.95 (number column) that is inserted into another table (varchar2 column)

After insert operation is completed I see that it is actually 1,96 ("," is because the territory defined as ITALY).

I know that  a precision can cause rounding, but as I said the insert is done into varchar2 column

My DB version is 11.2.0.3.0

Please advice
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 14 2015
Added on Apr 16 2015
#general-database-discussions
11 comments
436 views