Re: sql*loader question

Kirill Richine (kirill_at_cs.ualberta.ca) wrote:
: 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
: )

A related but kind of reverse question is, how do you define fields that do not correspond to any column.

For example, given the above input file and table T1, which has A, B, and C columns, how do I do this:

T1

A			B			C
aaaaa			bbbbbbbbbb		ccc1
aa			bbbbbbb			ccccccc2
aaaaaaaaaa		bbbbbbb			cccc3

In other words, how do I use recnum or sequence clause in combination with the actual data. I have tried the command below but it does not work

INTO TABLE T1
  fields terminated by "," (
    A,
    C ":c || :recnum",
    B
  )

Is this possible to do?

Thanks.
k. Received on Fri Jan 22 1999 - 21:15:29 CET