Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Can you load a comma delimitted text file into a table. but only take specified columns??

Can you load a comma delimitted text file into a table. but only take specified columns??

From: Anus <anus_at_anus.anus>
Date: Mon, 08 Jul 2002 18:55:25 -0400
Message-ID: <rh5kiukk33g1ufpeg5e1vir72icrnurkbt@4ax.com>


I have a really big comma delimted text file, with lots of fields

( example - 30 Fields)

but all i want to do is take field8, field15, and and field16

I know i could parse the file with awk or perl to have a uniform text file,

but i was wondering if SQL*Loader has a way to specify certain columns to be obtained from the text file???

( remember - it is comma delimited NOT a Position text file )
  Received on Mon Jul 08 2002 - 17:55:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US