Re: SQL-LOADER

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sat, 21 Aug 1999 17:51:42 GMT
Message-ID: <37bfe706.17224357@newshost.us.oracle.com>

A copy of this was sent to "Han Breurken" <Han.Breurken_at_nl.origin-it.com> (if that email address didn't require changing) On Thu, 19 Aug 1999 08:33:40 +0200, you 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
>

see the URL in my signature below for information on doing this.

Oracle8i release 8.1 -- keyword FILLER does it. Prior to that, unix cut or plsql can do it.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sat Aug 21 1999 - 12:51:42 CDT