Date: Tue, 8 Apr 2008 11:20:31 -0700 (PDT)
Say I have an external table with 4 columns like this. (Actual tables have more than 100 columns).
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?
John. Received on Tue Apr 08 2008 - 13:20:31 CDT