dbTalk Databases Forums  

Append unmapped field data to already mapped column in SQL Loader

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss Append unmapped field data to already mapped column in SQL Loader in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
shivammathur49@gmail.com
 
Posts: n/a

Default Append unmapped field data to already mapped column in SQL Loader - 09-24-2008 , 03:34 AM






Hello,
I have a CSV file which need to be loaded into database using SQL
loader. Below is my flat file data ...

I have three fields in CSV - Add1, Add2, Add3. I am able to map Add1
and Add2 to Address1 and Address2 columns in my table.

Now I want to append Add3 data to Address2 column. Is there any way I
can do this?

Many Thanks in advance.

Shivam

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.