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,
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