Help with SQLLDR - how to use a control file to process multiple date formats for the same column?
From: Jim <jim_esti_at_hotmail.com>
Date: 8 Jun 2001 09:57:14 -0700
Message-ID: <f0e3dc0b.0106080857.641b914e_at_posting.google.com>
Date: 8 Jun 2001 09:57:14 -0700
Message-ID: <f0e3dc0b.0106080857.641b914e_at_posting.google.com>
Hi,
In my control file I process dates with
RETURN_DATE date "YYMMDD" NULLIF RETURN_DATE = '0'. Similar code
exists for the other date related columns.
This does the trick for about 200 of the 20000 records. The date is
some times 6 digits and sometimes 5, 4 or 3 digits. As the date could
be 000101 (January 01, 2000) - but the text file just contains the
number 101 (the extract from the old DOS system drops the leading
zeros).
How can make the control file to process multiple date formats for the same column? Received on Fri Jun 08 2001 - 18:57:14 CEST