Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> sqlldr question.

sqlldr question.

From: Jan Eliasen <eliasen_at_cs.auc.dk>
Date: Sat, 15 Dec 2001 14:29:22 +0100
Message-ID: <Pine.GSO.4.33.0112151425040.4704-100000@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.
Received on Sat Dec 15 2001 - 07:29:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US