Re: SQL*Loader Question
From: Mike Daniell <mike_at_helix.com.au>
Date: Thu, 24 Sep 1998 12:34:40 +1000
Message-ID: <3609AFC0.64A9286F_at_helix.com.au>
Date: Thu, 24 Sep 1998 12:34:40 +1000
Message-ID: <3609AFC0.64A9286F_at_helix.com.au>
Vijay Damodaran wrote:
>
>
> Hi,
>
> I get a comma separated file containing thousands of records. Each row
> contains 29 columns. I need to
> load the data into a table, but I need only 11 of the 20 columns
etc
Vijay,
I presume from your control file that non of the fields can contain embedded commas. I suggest you use the Unix cut function to remove the unwanted fields from the data file, eg:
cut -d',' -f1,3,4,5,9,14,15,21,24,25 </tmp/people.list >/tmp/people.cut
Then use /tmp/people.cut as your data file.
Regards,
Mike
Received on Thu Sep 24 1998 - 04:34:40 CEST