Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlload, skipping colums?
A copy of this was sent to "Bas A. Schulte" <bas_at_yournews.nl>
(if that email address didn't require changing)
On Wed, 03 Mar 1999 13:29:56 +0100, you wrote:
>Hi,
>
>using sqlload, is it possible to skip certain columns? I.e. the source
>data containts multiple columns that I don't want to insert into a
>column in the database. I can't seem to find this anywhere in the
>documentation.
>
sqlldr with versions 8.0 and less cannot do this without a little help. See
http://www.dejanews.com/[ST_rn=ps]/getdoc.xp?AN=387206860
for a way to do this.
In 8i and up, sqlldr has syntax for skipping 'filler' fields in input files..
>This is my control-file:
>
>load data
>infile *
>into table TESTTABLE
>fields terminated by ',' optionally enclosed by '"'
>(
> COLUMN1,
> -- skip column from source here
> COLUMN2,
> COLUMN3
>)
>
>BEGINDATA
>"1","skip this","2","3"
>
>
>Thanks,
>
>Bas.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities