Re: skipping fields with SQL *loader

Thanks a lot!

P.S. Sorry about the name I used to post the first message, I was a bit quick while configuring my news-reader.

Werner Schram

Michel Cadot <micadot_at_netcourrier.com> schreef in berichtnieuws 8it3lp$2t8b$1_at_s2.feed.news.oleane.net...
> go to Thomas Kyte site, URL:
> http://osi.oracle.com/~tkyte/SkipCols/index.html
>
> --
> 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