Insert Question
From: Mtek <mtek_at_mtekusa.com>
Date: Tue, 8 Apr 2008 11:20:31 -0700 (PDT)
Message-ID: <2add9451-df1b-4fb8-bb45-57be5fe420bf@8g2000hse.googlegroups.com>
Date: Tue, 8 Apr 2008 11:20:31 -0700 (PDT)
Message-ID: <2add9451-df1b-4fb8-bb45-57be5fe420bf@8g2000hse.googlegroups.com>
Hi,
Say I have an external table with 4 columns like this. (Actual tables have more than 100 columns).
C1
C2
C3
C4
And the actual table is exactly the same. The easiest thing to do is to do a INSERT...SELECT.
However, say that I need to call a function on the first column to retrieve / convert a lookup value. How can I now do a INSERT / SELECT. I have 12 tables like this, and I do not want to create 12 triggers......
Does anyone have any suggestions?
Thank you,
John. Received on Tue Apr 08 2008 - 13:20:31 CDT