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!

Converting Exponential to number

694068Mar 25 2010 — edited Mar 25 2010

I have a value 1.23365465451346E21 in my database column.i want to convert it into number as display as 1233654654513456546546.What would be the sql query for that.please help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 22 2010

Added on Mar 25 2010

6 comments

26,381 views