Sql Loader [message #619667] |
Thu, 24 July 2014 05:01 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/d3e24490aeab7dd8dee68c9072fdefc3?s=64&d=mm&r=g) |
vatsav
Messages: 2 Registered: July 2014
|
Junior Member |
|
|
Hi
Im trying to use the sql loader functionality to load the data from a flat file separated by '|' delimiter.
Im struck with a scenario where i have the data which looks like the below
1234|a1|a2|a3|a.xml,b.xml,c.xml,d.xml|a4|a5|a6
could you please help me out here
|
|
|
|
|
Re: Sql Loader [message #619675 is a reply to message #619669] |
Thu, 24 July 2014 05:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/d3e24490aeab7dd8dee68c9072fdefc3?s=64&d=mm&r=g) |
vatsav
Messages: 2 Registered: July 2014
|
Junior Member |
|
|
I have used the below and trying to insert the sample data shown below
OPTIONS (ROWS=64)
LOAD DATA
characterset UTF8
INFILE '/amp/prosurv/sam/data/stats_customer.txt'
PRESERVE BLANKS
INTO TABLE NUPPAL1.STATS_CUSTOMER
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(col1,
Col2,
Col3,
Col4,
Col5,
Col6,
Col7)
Sample data
1234|a1|a2|a3|a.xml,b.xml,c.xml,d.xml|a4|a5|a6
In col5 i have data with a.xml,b.xml,c.xml,d.xml whihc I'm unable to insert in a singlecolumn
[Updated on: Thu, 24 July 2014 05:50] Report message to a moderator
|
|
|
|
|
|