Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlldr - ignore columns?
Yong Huang wrote:
>
> 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
Sorry - I should have said FILLER not skip...
Cheers
-- =========================================== Connor McDonald http://www.oracledba.co.uk We are born naked, wet and hungry...then things get worseReceived on Tue Aug 29 2000 - 08:05:14 CDT