Large number rounding in Oracle 10g

90 pts.
Tags:
Oracle 10g administration
Oracle 10g Database
Oracle Database
SQL Plus
TOAD
Oracle 10g database table with a column having data type Number(20) stores 18 digits organization code.  When this data is retrieved in SQL*Plus or Toad it is displayed in scientific notation format. The display format can be changed from scientific notation format to number format. But, for some reason the number rounds up. For example if the organization code stored in the database is 541200659999999999 when it is retrieved from database it is found to be 541200660000000000. Is there any one who knows why Oracle does this?  Thank you in advance for your help.



Software/Hardware used:
Oracle 10g

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: