SQL LOADER and datatype float

[Ina Schmitz]

Hi all,

I have a table with a column x of type float(126).
For my data, I have a comma separated values file. In this file, for column
x there occur values like 345.4667848 or also 345.466E-02.
In my ctl-file for the SQL LOADER, I wrote:
x CHAR "TO_NUMBER(:x, '999.9999999') for this column.

The first number 345.4667848 then is accepted, but the second number
345.466E-02 with the E in it is rejected. How can I change it so that SQL
LOADER loads BOTH numbers?

Thanks a lot for help!

Cheers,
Ina

[Guest]

you have to try

TO_NUMBER(TO_CHAR(:x, '999.999EEEE'),'999.999EEEE')

This should be work.