Transcoding with sqlldr
From: Singer <ysinger_at_aubay.com>
Date: Sat, 21 Jul 2001 21:54:07 GMT
Message-ID: <515d69ae.0106180545.481c2035_at_posting.google.com>
Date: Sat, 21 Jul 2001 21:54:07 GMT
Message-ID: <515d69ae.0106180545.481c2035_at_posting.google.com>
Hello,
Here is my problem :
I have a large simple data file wich look like that
Field 1 Value
name1 aaa
name2 bbb
i would like to load it into a table using a transcoding file or table
which could look like that :
Field1 Name1
name1 N1
name2 N2
because I want my final table to look like that :
Name1 Value
N1 aaa N2 bbb
Can anybody suggest me a best practice to enable this ?
Thanks,
Yannick Received on Sat Jul 21 2001 - 23:54:07 CEST