Re: sqlloader question

look into keywords: NULLIF, TRAILING NULLCOLS and go to http://asktom.oracle.com and look for sql loader. lots of great references there.

daniel wrote:
>
> what error do you get?
>
> --
> Regards,
>
> Daniel.
>
> "Shawn Edwards" <spedwards_at_qwest.net> wrote in message
> news:LTmv8.689$NU5.165342_at_news.uswest.net...
> > Hi,
> >
> > I've been struggling trying to load a .csv file into my temp table. My
> > table has 20 columns. But, not every line in the .csv file has 20 values.
> > Some have 20, some 15 and some 10. But, only 2 columns are NOTNULL. And
> > every line has those 2 values. But, I suspect that my problems are
 stemming
> > from the fact that not all of my lines in the .csv are 20 values for each
> > column.
> >
> > So, my question is this. When loading a file is there a special procedure
> > in creating the .csv file loading or additional step that I may have
 missed
> > with SQLOADER?
> >
> > Thanks
> >
> >
Received on Thu Apr 18 2002 - 04:36:37 CEST