Re: Skipping fields using SQL*Loader?
From: Dave Mausner <d-mausner_at_nwu.edu>
Date: 1995/04/28
Message-ID: <3npfna$pdf_at_news.acns.nwu.edu>#1/1
Date: 1995/04/28
Message-ID: <3npfna$pdf_at_news.acns.nwu.edu>#1/1
Recently, gbrown_at_partech.com (George Brown) posted:
>
>Can SQL*Loader skip fields when loading?
there's no explicit syntax for doing that when using comma terminated fields. but you could specify the same field a few times; the intermediate mentions will gobble up the fields you wish to skip, and the last mention will contain the desired field value. this used to work and still will if they didn't change the syntax to disallow multiple mentions of a column.
-- Dave Mausner, Senior Consultant, Braun Technology Group, Chicago.Received on Fri Apr 28 1995 - 00:00:00 CEST