Welcome, Guest
Please Login or Register.    Lost Password?

oracle sqlldr concatenate input fields
(1 viewing) (1) Guest
Discussions related to Database Technologies
Go to bottomPage: 1
TOPIC: oracle sqlldr concatenate input fields
oracle sqlldr concatenate input fields 10 Years, 11 Months ago Karma: 2
Need to concatenate input fields form an input file that goes into a single table column?

Use the sqlldr "boundfiller" option. This example shows how to embed constant text within
the data being input into the column.

load data
infile 'somefile.csv'
into table table1
fields terminated by ',' optionally enclosed by '"'
trailing nullcols
n0 filler, -- layer1
n1 filler, -- layer2
n2 filler, -- layer3 stub
n3 boundfiller, -- layer3 stub description
n4 boundfiller, -- layer4
n5 boundfiller, -- layer5
n6 boundfiller, -- layer6
n7 boundfiller, -- min
n8 boundfiller, -- max
n9 boundfiller, -- layer 9

description ":n3||' '||:n4||' '||:n5||'. Band Level '||:n6||' covering the range of '||:n7||'-'||:n8||' entries. '||:n9"
The administrator has disabled public write access.
Go to topPage: 1
Moderators: halls
get the latest posts directly to your desktop