Skip to Main Content
Forums

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!

Number format

715920Feb 23 2011 — edited Feb 24 2011
Dear all,
I'm trying to understand how format works in TO_NUMBER function. Suppose I have the following query: 
SQL> select to_number(12345678912345,999999999999999) from dual;

TO_NUMBER(12345678912345,999999999999999)
-----------------------------------------
			       1.2346E+13
Why TO_NUMBER function doesn't show all the 14 digits number? What does restrict it?

Best regards,
Val
This post has been answered by Mahir M. Quluzade on Feb 23 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 24 2011
Added on Feb 23 2011
6 comments
643 views