Re: SQL Loader: How to skip fields?

Steve Haynes wrote:
>
> In article <8781ar$n2f3_at_usilws15.ca-nethaven.com>, Tim Cope
> <copti03_at_cai.com> writes
> >You can specify the column as a FILLER and sqlldr will skip that column.
> >For example:
> >
> >INTO TABLE MYTEST
> >(
> >col1 CHAR(20),
> >col2 FILLER CHAR(30),
> >col3 CHAR(20)
> >)
> >
> New one on me, what version did this arrive in?,
> I'm sure it didn't used to be possible.
> Steve

Available in 8i.

Typically people use "cut" or equivalent in Unix as a pre-process to do the same in lower versions.

HTH

-- 
===========================================
Connor McDonald
"These views mine, no-one elses etc etc"
connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue."