Room: Club Parlor
MERGE() is a powerful function for processing data like transaction logs from point-of-sales systems. It is powerful as it allows you to insert, update, or delete data in one statement instead of using an application that requires numerous round trips between the server and the application to do the same tasks (which is much more resource and time intensive). However, this is not an easy function to learn from reading the manual. This session starts with the basics and builds so that you learn how to use the power of MERGE().