You can also have a combined field on the target table, which gets automatically populated, by creating a Trigger on the table. An example of a Trigger, before inserting any record ( Hint : Also, add a before updating trigger, similarly, with a different name ) as given in this forum article here : https://stackoverflow.com/questions/15445944/how-to-create-trigger-to-do-concatenation-of-fields Also, it is better to use : CREATE OR REPLACE TRIGGER instead of just CREATE TRIGGER in the above forum...
Home
Home
Home
Home
Home
Home
Home