Re: SQL*Loader and Date Fields
From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Mon, 10 May 1999 21:10:00 +0200
Message-ID: <7h7ati$bau$1_at_weber.a2000.nl>
Date: Mon, 10 May 1999 21:10:00 +0200
Message-ID: <7h7ati$bau$1_at_weber.a2000.nl>
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