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

From: LID <wdaccache_at_gmail.com>
Date: 2 May 2006 23:10:36 -0700
Message-ID: <1146636636.134123.269060_at_j73g2000cwa.googlegroups.com>



[Quoted] 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 Received on Wed May 03 2006 - 08:10:36 CEST

Original text of this message