Re: SQL*LOADER: Skipping over fields in text file?

LOAD DATA
INFILE *
REPLACE
INTO TABLE Address
(

	Name		POSITION(1) 	CHAR(20),
	Address	POSITION(41)	CHAR(20)

Change the POSITIONs to reflect the actual column numbers of the fields in your datafile.

James Reynolds <reynolds_at_monet.cs.athabascau.ca> wrote in article <55b65m$673_at_ftp.ee.vill.edu>...
> I'm new to using SQL*Loader, and am having some trouble importing
> selected fields from tab-delimited ASCII files.
>
> For example, my Oracle table contains two columns:
>
> Name varchar2(20)
> Address varchar2(20)
>
> While the text file looks like this (4 columns):
>
> John Doe JUNK FIELD1 JUNK FIELD2 123 Halloween Drive
> Mary Smith MORE JUNK EVEN MORE 567 Street Road
>
> I've tried various settings in the control file with no luck. Can anyone
> shed some light? Thanks in advance.
>
> Jim.
>
Received on Fri Nov 01 1996 - 00:00:00 CET