Re: NULL date using SQL*Loader

From: David Scott <dscott_at_is.net>
Date: 1995/10/20
Message-ID: <dscott-2010952032270001_at_dscott.is.net>#1/1

In article <466t5h$433_at_ixnews3.ix.netcom.com>, harihara_at_ix.netcom.com (Hariharan Suryanarayanan ) wrote:

> Hi,
>
> I am creating fixed length records and using Oracle SQL*Loader to load
> these records into a table. One of the fields is a date field for which
> I put values in mm/dd/yy format; I am not able to figure what value to
> use so that I can have a NULL value in this date field.
>
> eg.
> Data file
> xxxxxxxxxxxxxxxxxxxxxxxxx04/13/76
> yyyyyyyyyyyyyyyyyyyyyyyyy07/13/87
> zzzzzzzzzzzzzzzzzzzzzzzzz????????
>
> Control file for SQL*Loader
> name position (1:25),
> date position (26:33) "mm/dd/yy"
>

Your control file line:
 date position (26:33) "mm/dd/yy"
should read
 date position (26:33) "mm/dd/yy" NULLIF((26:33)='??????')

---

David Scott
...how can I keep from singing?
email: dscott_at_is.net

---

Received on Fri Oct 20 1995 - 00:00:00 CET