Re: Calling SQL functions with SQL loader to concatenate, ADD, etc... fields

LID wrote:
> 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

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

-- 
Sybrand Bakker
Senior Oracle DBA