Skip to Main Content

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 in Excel download

SidMoJul 26 2010 — edited Jul 27 2010
Hi. My application has an excel download functionality which works fine. Problem is that varchar2 fields in the download that have a numeric value get converted to number. This is still acceptable except for the numeric values that exceed 11 characters in length and are displayed with a notation(for e.g.,'1531621531624' is displayed as '1.53162E+12'). Is there any way to download these as character in excel ?

I've tried concatenating a special character to the column in the download query which, while effective, is not very pretty.

P.S. My application is built on PL/SQL and Mod PL/SQL.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 24 2010
Added on Jul 26 2010
9 comments
2,207 views