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!

avoiding exponential in results

NeilCSEDec 29 2009 — edited Dec 29 2009

Hi,

I want to avoid the exponent part in the result, plz help
SELECT SUM(TO_NUMBER(ID,'99999999999.9999999')) FROM Tab1;

1.2520E+11

Result I am getting is again in expo format.

Regards,
aak

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 26 2010

Added on Dec 29 2009

5 comments

2,770 views