Re: skipping fields with SQL *loader

From: Ms. D.H. Harvey <qq45_at_liverpool.ac.uk>
Date: 2000/06/22
Message-ID: <8it56g$351$1_at_news.liv.ac.uk>#1/1


z wrote:
: 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?

See http://govt.us.oracle.com/~tkyte/SkipCols/index.html

HTH Helen Received on Thu Jun 22 2000 - 00:00:00 CEST

Original text of this message