MERGE INTO EVENT e 
 USING (SELECT * 
 FROM new_event 
 WHERE event_type_id = 4) n 
 ON (e.event_id = n.event_id) 
 WHEN MATCHED THEN 
 UPDATE SET 
 e.event_type_id = n.event_type_id, 
 e.start_dt = n.start_dt 
 WHEN NOT MATCHED THEN 
 INSERT (event_id, event_name, event_type_id) 
 VALUES(n.event_id, n.event_name, n.event_type_id); 

Show comments for this question (1)
Add comments
Link to this question