Home » RDBMS Server » Server Utilities » SQL LOADER
SQL LOADER [message #187951] Wed, 16 August 2006 08:01 Go to next message
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 Go to previous message
BlackSwan
Messages: 25033
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.
Previous Topic: LOAD INVALID NUMBER
Next Topic: PLS-00103: Encountered the symbol ";" when expecting one of the following:
Goto Forum:
  


Current Time: Sat Dec 03 01:29:10 CST 2016

Total time taken to generate the page: 0.08531 seconds