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: sqlloader question

Re: sqlloader question

From: Bricklen Anderson <bricklen_at_shaw.ca>
Date: Thu, 18 Apr 2002 02:36:37 GMT
Message-ID: <3CBE3060.DD1A686F@shaw.ca>

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 Wed Apr 17 2002 - 21:36:37 CDT

Original text of this message

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