Re: SQL*Loader and Date Fields

From: Arjan van Bentem <>
Date: Mon, 10 May 1999 21:10:00 +0200
Message-ID: <7h7ati$bau$>

Plant Thomas
> is there a way to say to SQL*Loader to use in the controlfile a line like
> NULLIF data_inizio='00000000' OR NULLIF data_inizio = BLANKS

You may include *any* SQL statement enclosed in double qoutes, using :data_inizio to refer to the text found in the data file. Like:

    data_inizio POSITION(192:199) DATE(8)

        "decode( :data_inizio
               , null, null /* not required I guess */
               , '00000000', null
               , to_date(:data_inizio, 'YYYYMMDD'

Arjan. Received on Mon May 10 1999 - 21:10:00 CEST

Original text of this message