Re: DATE in SQL Loader

I recall having problems with having 2 format codes appearing for say the month part of a day or date.

e..g. ORACLE didn't like a format like MON-MM or Day-DD .

This seems to match up with the error message that you get.

greg teets wrote:

> I'm trying to load some date with SQLLoader that do not have a zero
> when the month or day is less than ten. I am currently using the
> following line in my .ctl file:
>
> QUOTE_DATE_DATE DATE "FXFMMM/MM/YY",
>
> I got this syntax from the section on Format Models in the manual.
> However, I got the error:
>
> ORA-01810: format code appears twice
>
> when I ran Loader.
>
> Am I on the right track? If not, please explain how to load records
> which drop the zero in this situation.
>
> Thanks in advance.
>
> Greg
Received on Thu Jul 31 1997 - 00:00:00 CEST