Re: SQL*LOADER - Question
From: Joe Nametko <Joseph.Nametko_at_alliedsignal.com>
Date: Mon, 03 Aug 1998 07:46:57 -0400
Message-ID: <35C5A330.BDD4BA0C_at_alliedsignal.com>
Date: Mon, 03 Aug 1998 07:46:57 -0400
Message-ID: <35C5A330.BDD4BA0C_at_alliedsignal.com>
Why don't you load the entire file to a work table and then populate your actual table with the 2 fields? Rather than play around with loader, I find this to be a quick fix.
Juan Carlos Rodriguez wrote:
> Hello !
>
> I have a problem loading data with SQL*LOADER.
> The datafile to load has 4 variable length fields terminated by commas.
> I only need two fields but they aren't contiguous.
>
> For example, supose this data file:
> 1,"one","first","A"
> 2,"two","second","B"
> 3,"three","third","C"
> ...
> We only need the columns 1 and 3, discarding the columns 2 and 4.
>
> Any suggestion ?
>
> Thanks a lot
>
> Juan Carlos Rodriguez
> D.B. Administrator
Received on Mon Aug 03 1998 - 13:46:57 CEST