Summary

This chapter discussed how you import data in Oracle and MySQL databases. It showed you the process of leveraging external import sources through external files in Oracle and through the LOAD DATA and LOAD XML statements in MySQL.

Sample programs showed you how to take denormalized import source files and merge them into relational tables. You also learned how you can use the Oracle MERGE statement and the INSERT ON DUPLICATE KEY and REPLACE INTO statements in conjunction with outer joins to merge data with existing tables.