Convert Exponential values in Numbers???

[#1]

Please find the attached document,

In my application, you'll notice that in Column TO_BALANCE containing data like 1e+017,

but i need to present the data which is not in the exponential form

i:e:- 100000000000000000

Regards.

Zain

[jvitantonio]

Hi,

Use

LOAD num(TO_BALANCE,'##################'),

     ACTUAL_RATE

FROM ...

[#3]

i applied it but, still have the same problem

[sivarajs · Accepted solution]

Try using this

num(num#(TO_BALANCE),'##################') as TO_BALANCE