DSXchange

thankx craig,

The data did load perfectly but i want the data to be in te following format

I want the data to be converted into the following format:

Target

3001.23
200.20
2345.00
2323.00
1876.12

where as the data which is loaded does not have zeros and also that i need 2 digits compulsorily after the decimal.

Those zeroes are not significant. You have no control over how the data in a NUMBER field is stored internally in Oracle. You are arguing about an external representation, which is strictly an artifact of how you select the data.

Try this:
With enough nines to cover the size of your field or your largest value. Look more better?

Yes you are right, the loading of data does not depend on us. I changed the datatype to char and this time it worked.

Thank you for your patience,time and effort.

It worked all the other times, too.