Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 - 00:00:00 CST