How to achieve "merge" of two data sets with Insert SQL statemen (Oracle DBMS)t?
- by Roman Kagan
Hi:
What would be the insert SQL statement to merge data from two tables. For example I have events_source_1 table (columns: event_type_id, event_date) and events_source_2 table (same columns) and events_target table (columns: event_type_id, past_event_date nullalbe, future_event_date nullable).
Events_source_1 has past events, Events_source_2…