| SQL LOADER [message #187951] |
Wed, 16 August 2006 08:01  |
mgiridaran
Messages: 1
Registered: August 2006
Location: Sri lanka
|
Junior Member |
|
|
DEAR ALL
this is regarding the SQL loader.I have to import a flat file to oracle database.
but the no of field in the each line of the file vary to one another (ie. some records )
contain 12 filds,some 11 etc) so when loaded to oracle table columns are not in order.
pls tell me how to attend this.
sample format
aaa,bbb,cccc,
ddd,eee,ffff,rrrrr
jjjj,lll,kkkk,hhhh,dddd
Thank You
|
|
|
|
| Re: SQL LOADER [message #188307 is a reply to message #187951] |
Thu, 17 August 2006 20:11  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
>pls tell me how to attend this.
Have the folks who are creating the flat files to create them using a consistant format.
Garbage out, Garbage In.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
