Re: SQL*LOADER: Skipping over fields in text file?
Date: 1996/11/02
Message-ID: <55ejim$sla_at_news.istar.ca>#1/1
Try this :
-- 1 2 3 -- 123456789012345678901234567890123456789012345678901234567890 -- John Doe JUNK FIELD1 JUNK FIELD2 123 Halloween Drive -- Mary Smith MORE JUNK EVEN MORE 567 Street RoadABOVE IS COMMENTED OUT JUST FOR REFERENCE... LOAD DATA INFILE 'names.dat'
insert into addresses (
Name position(001-012) char, Address position(039-050) char )
Be VERY specific when defining the positions.This numbering system at the top can be extremely useful. Loader will only load what YOU tell it to and ignores everything else. Goodluck, Rob
reynolds_at_monet.cs.athabascau.ca (James Reynolds) wrote:
>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 Sat Nov 02 1996 - 00:00:00 CET