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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 24 2010

Added on Jul 26 2010

9 comments

2,164 views