Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

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.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint