sql loader Problem [message #390343] |
Fri, 06 March 2009 01:12 |
athene
Messages: 11 Registered: January 2009
|
Junior Member |
|
|
I need data in the table as
table csv_test
----------------
C1 C2 C3
1 3 8
9 3 5
but the csv file provided to me is in the format
C1,1,9
C2,3,3
C3,8,5
How can I use sql loader to load data into the above mentioned table.
Thanks in advance
|
|
|
|
|
Re: sql loader Problem [message #390385 is a reply to message #390343] |
Fri, 06 March 2009 03:26 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
Depends on your environment too. You can fix the datafile before loading. In this case, a simple awk script.
oracle@chum#cat first.csv
C1,1,9
C2,3,3
C3,8,5
oracle@chum#transpose.awk first.csv
C1 C2 C3
1 3 8
9 3 5
|
|
|