Q: SQL*Loader w/ variable fields
From: Neil Greene <neil_at_kynug.org>
Date: Thu, 23 Sep 1993 19:53:24 GMT
Message-ID: <1993Sep23.195324.2442_at_KYnug.org>
Date: Thu, 23 Sep 1993 19:53:24 GMT
Message-ID: <1993Sep23.195324.2442_at_KYnug.org>
I have looked through the manual several times and I was just wondering...
If, I have a variable length data file delimited by commas, optionally
enclosed by quotes, containing: field1, field2, field3, field4, field5,
..., fieldn-1, fieldn
and
I only want to read in field1, field2, field4, field5, ..., fieldn
How can I get sql*load to skip the omitted fields in a variable length
data file delimited by commas?
Can I simply enter "," in my sql*load file as place holders, skipping over
the data??
--
Neil Greene
President, benchMark Developments, Inc. [NeXT VAR]
President, Kentucky NeXT User Group, Inc.
North American, TIFFany Distributor
Received on Thu Sep 23 1993 - 21:53:24 CEST