Home » RDBMS Server » Server Utilities » SQL Loader control file to create duplicate row
icon6.gif  SQL Loader control file to create duplicate row [message #252862] Fri, 20 July 2007 07:39 Go to next message
prithivirajan
Messages: 2
Registered: July 2007
Junior Member
Hi all,

I have data file like below,

NF8,TLEV,F
NF9,"EXPORT,UNLEADED",F
NM2,"EXPORT,LEADED",C

I need to import this data into table, whereas the secound& third row should be duplicated since it has internal comma's

Final value in table should be,
NF8 TLEV F
NF9 EXPORT F
NF9 UNLEADED F
NM2 EXPORT C
NM2 LEADED C

Please help me with your ideas...
Re: SQL Loader control file to create duplicate row [message #252882 is a reply to message #252862] Fri, 20 July 2007 08:22 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It would, perhaps, be easier if you used external table feature instead of SQL*Loader. Doing so and using (PL/)SQL, you might parse every record and do with it whatever you want.
Re: SQL Loader control file to create duplicate row [message #252886 is a reply to message #252862] Fri, 20 July 2007 08:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You can't do it with SQL*Loader.
Go to external table as has been said.

Regards
Michel
icon14.gif  Re: SQL Loader control file to create duplicate row [message #252887 is a reply to message #252886] Fri, 20 July 2007 08:37 Go to previous message
prithivirajan
Messages: 2
Registered: July 2007
Junior Member
Thank u ... http://www.orafaq.com/forum/images/message_icons/icon14.gif
Previous Topic: SQL LOADER : How to specify sysdate with infile name?
Next Topic: Exporting Schema with all the objects(no data)
Goto Forum:
  


Current Time: Thu Dec 05 07:30:16 CST 2024