misunderstanding between DEFAULTIF and NULLIF with SQLLOader

From: Maya Kenner <maya.kenner_at_trema.com>
Date: Thu, 04 Oct 2001 06:53:53 -0700
Message-ID: <F001.003A1C16.20011004062019@fatcity.com>

Hello
,
<SPAN

class=975355512-04102001> 
I have a small
problems because of empty fields and NULL fields.
<SPAN

class=975355512-04102001> 
I have a data file
extracted from a non-Oracle DB where the empty field is represented by a single space char and NULL field is represented with nothing , ||| is field delimitor , #|# is line delimitor
<SPAN

class=975355512-04102001> 

toto||| 
|||#|#
tutu|||||| 

#|#
<SPAN

class=975355512-04102001> 
select * from
mytable
<SPAN

class=975355512-04102001>col1    col2     col3
<SPAN

class=975355512-04102001>toto                NULL
<SPAN

class=975355512-04102001>tutu     NULL   

<SPAN

class=975355512-04102001> 
How can I build my
control files so that SQL Loader insert a chr(0) if there is a space and a NULL if empty ?
<SPAN

class=975355512-04102001> 
Thanks,
Maya Received on Thu Oct 04 2001 - 08:53:53 CDT