Re: SQL*Loader problem

Jan Ekl=3D?iso-8859-1?Q?=3DF6f ?=3D wrote:
> =
 

> Hi all!
> =
 

> Having trouble loading data into an oracle 7.1 db with SQLLOAD.
> =
 

> 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 ?
> =
 

> TIA
> Jan Ekl=F6f

Try the following for the field in question =

field position (1:4) DECIMAL EXTERNAL(4) ":field/10" -- =

Regards,

Varad Acharya Received on Tue Sep 17 1996 - 00:00:00 CEST