Append unmapped field data to already mapped column in SQL Loader
From: <shivammathur49_at_gmail.com>
Date: Wed, 24 Sep 2008 01:34:16 -0700 (PDT)
Message-ID: <cae5b8d5-b475-402f-8afa-03668f570978_at_f36g2000hsa.googlegroups.com>
Hello,
I have a CSV file which need to be loaded into database using SQL loader. Below is my flat file data ...
Date: Wed, 24 Sep 2008 01:34:16 -0700 (PDT)
Message-ID: <cae5b8d5-b475-402f-8afa-03668f570978_at_f36g2000hsa.googlegroups.com>
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 Received on Wed Sep 24 2008 - 10:34:16 CEST