Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help: SQLLDR and NULL values
Hi.
Sorry, but as far as I know - you don't have any other option. Try first creating a file with 10-20 records only and test it.
Michael.
In article <80d46r$pq9$1_at_nnrp1.deja.com>,
la_quake_at_my-deja.com wrote:
> In article <80cpi3$ht9$1_at_nnrp1.deja.com>,
> michael_bialik_at_my-deja.com wrote:
> > Hi.
> >
> > 1. Generate your data again use blanks instead of NULL :
> > 1234 XYZ
> >
> > 2. Change your load command :
> > field1 char(4),
> > field2 char(5) NULLIF (field2)=BLANKS
> > field3 char(3)
> >
> > HTH. Michael.
> >
>
> Hi Michael, I have a question. The above is a sequence of things that
> I need to do or options from which I can choose? Thanks.
>
> > In article <80ch4m$auj$1_at_nnrp1.deja.com>,
> > la_quake_at_my-deja.com wrote:
> > > Hello everyone, here is the problem:
> > >
> > > SQLLDR keeps insisting that there are no NULLs in my data and so
> what
> > > it does, it moves the next data over to where NULL was. For
> example,
> > > the following fixed data:
> > >
> > > 1234<NULL>XYZ
> > >
> > > is converted to
> > >
> > > 1234XYZ
> > >
> > > by SQLLDR. How can I make SQLLDR to see the NULL? Thanks in
> advance
> > > for your help.
> > > --
> > > Please visit the following site to get to know the real Sathya Sai
> > Baba:
> > > http://www.myfreeoffice.com/saibabaexposed/index.html
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> > >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> --
> Please visit the following site to get to know the real Sathya Sai
Baba:
> http://www.myfreeoffice.com/saibabaexposed/index.html
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Nov 11 1999 - 14:33:39 CST