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 -> Re: sqlldr & date?

Re: sqlldr & date?

From: Glen A Stromquist <glen_stromquist_at_nospam.yahoo.com>
Date: Fri, 11 Oct 2002 14:17:16 GMT
Message-ID: <M3Bp9.8499$wU3.351219@news0.telusplanet.net>

> On Thu, 10 Oct 2002 22:25:38 GMT, Glen A Stromquist
> <glen_stromquist_at_nospam.yahoo.com> wrote:
> 

>>control file LOAD.CTL:
>>
>>load data
>>infile file.csv
>>insert into table schema.table
>>fields terminated by ","
>>(DATEOF "DD-MON-YY",
>>NUM1,
>>NUM2,
>>NUM3,
>>NUM4,
>>NUM5,
>>NUM6,
>>NUM7)

---snipped

I ended up just taking the "DD-MON-YY" out of the ctl file and it worked. I'm still a bit mystified though, as I'm sure thats what I tried in the 1st place! Received on Fri Oct 11 2002 - 09:17:16 CDT

Original text of this message

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