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 -> Re: skip field in delimited file for sql*loader

Re: skip field in delimited file for sql*loader

From: FC <flavio_at_tin.it>
Date: Wed, 22 Jan 2003 19:54:20 GMT
Message-ID: <MFCX9.91870$AA2.4066270@news2.tin.it>

"Andrew" <andyho99_at_yahoo.com> wrote in message news:8882aa3c.0301221025.1cffe1a0_at_posting.google.com...
> Hi,
>
> Is there a way to skip a field in a delimited file? In a fixed format
> file, I can specify the position using POSITION keyword. The goal is
> not to change input file if possible. Thanks.

did you try using FILLER ?
I think this is what you're looking for. Received on Wed Jan 22 2003 - 13:54:20 CST

Original text of this message

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