Home
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