Re: SQL*Loader problem

>The datafile to be loaded have a field with a numerical value which
>has 1 decimal (definition in oracle table: NUMBER(4, 1) ).
>
>In the datafile, the value is written in character form:
> 0110
>which is the value 11.0.
>
>How can I write the controlfile for SQLLOAD to make SQLLOAD
>understand that the last character in this field is a decimal ?
>
 11 is the same as 11.0, so you cannot store 11.0

-- 
=========================================================
            http://www.li.net/~gsa/index.html
This is my signature file, not part of this mail message.