Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Can you load a comma delimitted text file into a table. but only take specified columns??
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
![]() |
![]() |