Re: Managing date field

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"

[Quoted]         "DECODE (:DR_S_I, '00000000', NULL,
                          '        ', NULL,
                                      :DATE_FIELD)")

Igor Terzic
Probanka Maribor Received on Wed Mar 05 1997 - 00:00:00 CET