Re: SQL-LOADER

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Fri, 20 Aug 1999 03:44:54 GMT
Message-ID: <37cccbfe.52398575@netnews.worldnet.att.net>

I *think* that you can use the FILLER keyword to skip a column. For example:

        column_name FILLER CHAR TERMINATED BY ','

I know this works under Oracle8i, but I'm not sure about previous releases.

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are

On Thu, 19 Aug 1999 08:33:40 +0200, "Han Breurken" <Han.Breurken_at_nl.origin-it.com> wrote:

>Hello,
>
>Is it possible to skip columns when using a delimeted input datafile.
>
>Exp.
>file:
>10;aaa;bbb;ccc
>
>In the database I only need the first and the last column. Is there a way to
>do that.
>
>Thanks,
>Han
>
Received on Thu Aug 19 1999 - 22:44:54 CDT