Re: Calling SQL functions with SQL loader to concatenate, ADD, etc... fields
From: Volker Pohlers <vpohlers_at_arcor.de>
Date: Wed, 03 May 2006 10:40:15 +0200
Message-ID: <44586c6f$0$11071$9b4e6d93_at_newsread4.arcor-online.net>
)
BEGINDATA
12,Test,X,12,13
13,Test2,Y,14,16
Date: Wed, 03 May 2006 10:40:15 +0200
Message-ID: <44586c6f$0$11071$9b4e6d93_at_newsread4.arcor-online.net>
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
Received on Wed May 03 2006 - 10:40:15 CEST