Re: SQL*Loader question

I'm not at work, so I can't try this out ... but this should work.

If you are using Oracle 8i or later, you can define field1 and field2 as FILLER and then

LOAD DATA
INFILE 'input.dat'
INSERT INTO TABLE whatever
FIELDS TERMINATED BY ',' ENCLOSED BY '"' (
field1 FILLER CHAR,
field2 FILLER CHAR,
col1 CHAR ":field1||:field2||:col1"
)

hope that gives you some ideas.

drew

On 11-Apr-2002, Laurent <Laurent_at_bernes.com> wrote:

> Hello,
>
> Is it possible to concatenate many fields into one field from a delimited
> input
> file.
>
> eg I have 3 fields in my text file and I would want to concatenate these 3
> fields into one column in my target ORACLE table.
>
> ":field1", ":field2", "field3" => Columnn 1
>
> Thanks in advance.
>
> --
> Use our news server 'news.foorum.com' from anywhere.
> More details at: http://nnrpinfo.go.foorum.com/
Received on Fri Oct 18 2002 - 23:35:28 CDT