Hi All,

I have a flat file as follows:
ID,Name1,Name2,height1,height2
12,Test,X,12,13
13,Test2,Y,14,16

I need an sql loader control file that concatenates Name1 and Name2
into one db field and add up height1 and height 2 into one field so
that I can get the following result in the following table:

ID, Name, Height
12, TestX, 25
13, Test2Y, 30

Thanks a lot for providing me with a CTL file example that can do that.

Regards,
Walid

Hi, this works (tested on Oracle 9.2):

load data
infile *
replace
into table EXT_TEST
fields terminated by ','
trailing nullcols
(
ID,
NAME1 BOUNDFILLER,
NAME ":NAME1||:NAME",
HEIGHT1 BOUNDFILLER,
HEIGHT ":HEIGHT1+:HEIGHT"
)
BEGINDATA
12,Test,X,12,13
13,Test2,Y,14,16

------------

ID NAME HEIGHT
-- ---------- --------------
12 TestX 25
13 Test2Y 30


greetings
Volker

LID wrote:
Please don't ask doc questions here, but read the manual.

--
Sybrand Bakker
Senior Oracle DBA