Re: sqlldr question.

"Jan Eliasen" <eliasen_at_cs.auc.dk> wrote in message news:Pine.GSO.4.33.0112151425040.4704-100000_at_borg.cs.auc.dk...
> Hi there.
>
> I have a datafile with lines like this;
> 0080 A. C. Jacobsens Vej 5 34 9400 Norresundby
>
> 0080 is one field.
> "A. C. Jacobsens Vej" is the second field.
> The rest are one field a piece.
>
> I have the following control file;
> LOAD DATA
> INFILE 'RoadNames.dat'
> REPLACE
> INTO TABLE RoadNamesTemp
> (Road_Code TERMINATED BY WHITESPACE,
> Road_Name TERMINATED BY [0-9],
> LowHouseNo TERMINATED BY WHITESPACE,
> HighHouseNo TERMINATED BY WHITESPACE,
> Postal_Code TERMINATED BY WHITESPACE,
> Postal_District TERMINATED BY WHITESPACE)
>
> It does not work. The problem being of course the [0-9] thingy. What do I
> do instead? I want the field to be terminated by a number - any number. I
> can't find anything in the documentation. Can it really be so that you can
> only terminate by a string, whitespace or a single character?
>
> Please help.
>
> --
> Eliasen Jr.
>

You need to use 'integer external' for the number columns

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address