SQL LOADER and datatype float

brandtner2000@gmx.de · *nix forums beginner Joined: 13 Mar 2005 Posts: 1

you have to try

TO_NUMBER(TO_CHAR( Mad

, '999.999EEEE'),'999.999EEEE')

This should be work.

Ina Schmitz · *nix forums beginner Joined: 04 May 2005 Posts: 39

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( Mad

, '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

Google