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!

TO_CHAR not Scientific Notation

720975Sep 16 2009 — edited Sep 16 2009

I want to convert a number to a string but guarantee that the result will NOT be in scientific notation.
TO_CHAR(num, '9999999999.99999999999999') is not very convenient since the data type of the number is BINARY_DOUBLE and I will not know how many significant figures the number will have.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 14 2009

Added on Sep 16 2009

14 comments

6,612 views