Re: Managing date field

In article <331D233D.682E_at_probanka.si>, Igor Terzic <igor.terzic_at_probanka.si> says:
>
>colin wrote:
>>
>> I am using SQL*Loader to load ASCII text files into the database.
>> I had defined several field in my tables as DATE field, but in the event of
>> loading,
>> it gave me error while trying to load NULL to a DATE field. How can I
>> avoid this error.
>> My intention is to allow the DATE field to accept NULL.
>>
>> Please advise,URGENT.
>>
>> Thanks.
>>
>> email : evonliow_at_singnet.com.sg_at_internetTry putting this decode statement into your .ldr file.
>
>LOAD DATA
>INTO TABLE table
> (DATE_FIELD POSITION(067:074) DATE "YYYYMMDD"
> "DECODE (:DR_S_I, '00000000', NULL,
> ' ', NULL,
> :DATE_FIELD)")
>
>Igor Terzic
>Probanka Maribor

Try

LOAD DATA
NTO TABLE table
  (DATE_FIELD POSITION(067:074) DATE "YYYYMMDD"

                         nullif(DATE_FIELD = blanks),