IEEE conversion
I have following type of values in my database column with varchar2 datatype. I want to convert it into number. this is IEEE standard data. need to convert exactly into number. is there any way to do it if yes please let me know.. 1.84E-11
1.70E-01
0.00E00
1.23E-09
1.84E-04
5.13E-02
2.53E-08
7.69E-02
3.25E-09
2.13E-04
0.00E00
4.31E-10
8.12E-09
3.38E-10
2.44E-06
0.00E00
2.16570093421222E-07
6.18771695489207E-08
0