Insert Question

From: Mtek <>
Date: Tue, 8 Apr 2008 11:20:31 -0700 (PDT)
Message-ID: <>


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?

Thank you,

John. Received on Tue Apr 08 2008 - 13:20:31 CDT

Original text of this message