Exponent Issue

[vbaskar]

Hi

I have a character field which has got the value in EXPONENT FORM..

EXAMPLE : 5.20626E+11
The Actual Number Value for this is 520626065025..

So how do i convert an EXPONENT FORM TO NORMAL FORMAT..


Vijays

[tamilselvan]

Use to_number function.
E.g.
SQL> select to_number('234E5') from dual;

TO_NUMBER('234E5')
------------------
23400000

[vbaskar]

i ve tried that already!!! take this '5.20626E+11' figure and try whether u r getting 520626065025 by converting it to number !! it wont !!!

[kmesser]

If this is merely a display issue, could you select:

to_char(YourNumField,'99999999999999999999999999999999999999') from dual;

?
Then if you need to do math, convert it back. The math still works correctly.

[jmodic]

The format model for scientific notation is 'EEEE', that is 4 letters "E".

SQL> set numwidth 12
SQL> select to_number('5.20626E+11','9.99999EEEE') from dual;

TO_NUMBER('5.20626E+11','9.99999EEEE')
--------------------------------------
520626000000

SQL>

HTH,