Number conversion

reddy · Post by **reddy** » Thu Oct 16, 2008 2:36 pm

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.

chulett · Post by **chulett** » Thu Oct 16, 2008 2:49 pm

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:

Code: Select all

select to_char(YourField,'99999999.99') from YourTable

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

reddy · Post by **reddy** » Thu Oct 16, 2008 3:03 pm

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.

chulett · Post by **chulett** » Thu Oct 16, 2008 3:53 pm

It worked all the other times, too.