Re: SQL*Loader problem

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 ?

Hello Jan  

In your control file, you have to put :

...,

	col_name	POSITION(begin:end)	CHAR	"col_name/10",


	...,

-- 
email 'bthomas_at_teaser.fr'