-
SQL Loader control file to create duplicate row
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
Thanks for your suggestion and effort taken to think abt it , Any kind of ideas is welcomed
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|