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.
Number conversion
Moderators: chulett, rschirm, roy
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?
Try this:
Code: Select all
select to_char(YourField,'99999999.99') from YourTable
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers