Hello
,
I have a small
problems because of empty fields and NULL fields.
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
toto|||
|||#|#
tutu||||||
#|#
select * from
mytable
col1 col2
col3
toto
NULL
tutu NULL
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 ?
Thanks,
Maya
