Re: Loading dates via SQL*Loader

On 07-Mai-98 19:31:46 vjavaly wrote:

>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?

Try this:

prc_tms position(536:554) date "MM/DD/YYYY HH24:MI:SS" nullif blanks

You eventually have to adjust the syntax slightly as I'm writing this at home and I don't have my control files from my work at hand to check.

Hope that helps,
Lothar

--

Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Schulstr. 12            | lothar.armbruester_at_t-online.de
D-65375 Oestrich-Winkel |