Re: skipping fields with SQL *loader

From: Michel Cadot <micadot_at_netcourrier.com>
Date: 2000/06/22
Message-ID: <8it3lp$2t8b$1_at_s2.feed.news.oleane.net>#1/1


go to Thomas Kyte site, URL:
http://osi.oracle.com/~tkyte/SkipCols/index.html

--
[Quoted] Have a nice day
Michel


<z> a écrit dans le message : 39520421$0$78798_at_news2.zeelandnet.nl...

> I'm trying to import a table from a comma terminated text file using SQL
> *loader.
> In this text file there are 18 fields from wich I only need 6. The first
> field I need is
> the 7th one, so I need to skip the first 6 fields, but these fields have
> variable sizes,
> so the position keyword doesn't seem to work. I can't find anything about
> that in
> my documentation. Can anybody help me?
>
>
Received on Thu Jun 22 2000 - 00:00:00 CEST

Original text of this message