OraFAQ Forum: Server Utilities » SQL Loader control file to create duplicate row

Home » RDBMS Server » Server Utilities » SQL Loader control file to create duplicate row

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL Loader control file to create duplicate row [message #252862]

Fri, 20 July 2007 07:39

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...

Report message to a moderator

Re: SQL Loader control file to create duplicate row [message #252882 is a reply to message #252862]

Fri, 20 July 2007 08:22

Littlefoot
Messages: 21811
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.

Report message to a moderator