SQL LOADER and datatype float

From: Ina Schmitz <klose_at_fmi.uni-passau.de>
Date: Fri, 11 Mar 2005 10:09:48 +0100
Message-ID: <d0rn8t$r9s$05$1_at_news.t-online.com>

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 Received on Fri Mar 11 2005 - 10:09:48 CET