Xref: alice comp.databases.oracle.misc:49128
Path: alice!news-feed.fnsi.net!enews.sgi.com!harbinger.cc.monash.edu.au!bunyip.cc.uq.edu.au!inetbws1.citec.com.au!not-for-mail
From: Jerome Chik <jerome.chik@citec.com.au>
Newsgroups: comp.databases.oracle.misc
Subject: SQL*Loader questions
Date: Mon, 13 Dec 1999 15:44:26 +1000
Organization: CITEC
Lines: 24
Message-ID: <385487BA.C71B459@citec.com.au>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.6 [en] (Win95; I)
X-Accept-Language: en

Hi,

My datafiles are delimited, e.g. by |

(1) How do I make a field of four blank spaces, enclosed by delimiters,
to be loaded as a NULL instead of four spaces?

(2) How do I make the last field, if it starts with a delimiter and does
not contain anything but a carriage return, to load a NULL instead of a
carriage return? (I believe this was what happened).  e.g., the
following has four columns, the last one is supposed to be a null
column, i.e. after the last delimiter:

first field|second field|third field|
first field|second field|third field|


Thanks in advance,

Jerome.