Re: sqlldr - ignore columns?

From: <matthew_d_keene_at_my-deja.com>
Date: Tue, 29 Aug 2000 00:09:11 GMT
Message-ID: <8oeuuq$hlp$1@nnrp1.deja.com>

In article <JJOp5.2857$NR3.435877_at_news1.cableinet.net>, "Russell England" <russ_at_css2.com> 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
>
>

If you have Oracle 8i you can define the field as FILLER, which will stop it from being loaded into the database

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Aug 28 2000 - 19:09:11 CDT