Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Loading dates via SQL*Loader
In article <6isumj$eg4$1_at_nnrp1.dejanews.com>, vjavaly_at_hotmail.com writes
>I'm loading 100,000+ rows into Oracle8.0.3 from fixed format flat files using
>SQL*Loader. I want to use direct path load, but I cannot because some of my
>date fields may be blank and I've had to apply the following SQL string in my
>control file for these date fields: prc_tms POSITION(536 :554 ) CHAR
>"DECODE(:prc_tms,NULL,NULL,TO_DATE(:prc_tms,'MM/DD/YYYY HH24:MI:SS'))"
>
>How can I eliminate the above SQL string so I can use direct path load?
>
>Thank you.
Try something like:
prc_tms POSITION(536 :554) DATE "MM/DD/YYYY HH24:MI:SS"
(add a NULLIF clause if you need to)
E-mail me if that doesn't work.
--
Paul Brewer
Received on Sun May 10 1998 - 10:47:35 CDT