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!

How to convert the exponential data into number

Sarma12May 25 2012 — edited May 25 2012

Hi,

I have a table with a column which is a vaarchar2(60). I have a CSV file in which, I have stored value as 77052512125510000, but it got converted into 7.71E16. And when I have stored the same in the database, it got saved as 7.71E16. How can I get the original value

Please help

Regards

Edited by: Sarma12 on May 25, 2012 3:11 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 22 2012

Added on May 25 2012

12 comments

6,587 views