Re: SQL Loader and delimited fields

Geoff:

I had a similar problem. I used Perl with DBI/DBD to do the load instead of using SQL*Loader. It ran just as fast, plus, I could do things like you asked.

Rob

Geoff wrote in message <6lkfbo$f6b$1_at_scoop.suba.com>...
>Does anyone know how to skip a field when using SQL*Loader and a delimited
>flat file? I have a file with 5 fields per record. The fields vary in
>length between records, so I must use a delimited file format. My table
has
>4 columns, and I need to load the first three fields into into the first
>three columns, but the fifth field must go into the fourth column. How can
>I skip the fourth field?
>
>Thanks in advance!
>
>
Received on Thu Jun 11 1998 - 21:20:55 CEST