Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: sqlldr - ignore columns?
I made the same mistake in believing so. SKIP is for skipping rows (records as sqlldr calls), not columns.
Yong Huang
yhuang_at_indigopool.com
Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message
news:39AA3E7B.34E9_at_yahoo.com...
> Russell England wrote:
> >
> > I have several csv files that I want to load, but the csv files have
some
> > columns that I want to ignore:
> >
> > LOAD DATA
> > INFILE *
> > INTO TABLE mytable
> > FIELDS TERINATED BY "," OPTIONALLY ENCLOSED BY '"'
> > (Field1,Field2,,Field3,Field4)
> > BEGINDATA
> > "keep","keep","lose","keep","keep"
> > "keep","keep","lose","keep","keep"
> > ...
> >
> > How can I ignore the middle column?
> >
> > Thanks in advance
> >
> > Russ
>
> In 8i+ you can skip columns in SQL Loader - check the doco on the SKIP
> clause. In earlier versions, (if you are on unix), a little creative
> use with awk, cut et. al can modify the file before applying to sqlldr.
>
> HTH
> --
> ===========================================
> Connor McDonald
> http://www.oracledba.co.uk
>
> We are born naked, wet and hungry...then things get worse
Received on Mon Aug 28 2000 - 13:35:01 CDT
![]() |
![]() |