Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> sqlldr question.
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.Received on Sat Dec 15 2001 - 07:29:22 CST