Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help: SQLLDR and NULL values

Re: Help: SQLLDR and NULL values

From: <la_quake_at_my-deja.com>
Date: Thu, 11 Nov 1999 00:55:56 GMT
Message-ID: <80d46r$pq9$1@nnrp1.deja.com>


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. Received on Wed Nov 10 1999 - 18:55:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US