sql*loader question

From: Kirill Richine <kirill_at_cs.ualberta.ca>
Date: 1999/01/22
Message-ID: <78akiq$65b$1@scapa.cs.ualberta.ca>#1/1

hi!

Is it possible to skip columns (fields) when using delimited records?

For instance, I have table T with columns A and B but the file I am loading from has data like

aaaaa, ccc, bbbbbbbbbb
aa, ccccccc, bbbbbbb
aaaaaaaaaa, cccc, bbbbbbb
...

INTO TABLE T
  fields terminated by "," (
    A,
    ???,
    B
  )

What do I put instead of ??? to skip ccc, ccccccc, and cccc fields in first, second, and third records respectively?

Note that the fields are variable-width, so I can't use position.

Thanks.
k& Received on Fri Jan 22 1999 - 00:00:00 CST